SNP are currently governing with a (small) minority.
Because the motion of no confidence is in Humza, not the govt, it's unlikely to topple the SNP. I think.
Scottish Labour have improved but still are second to SNP in polls. Scottish Labour are a dilute version of UK Labour, eeeeeeeeeeeeever so slightly less batshit than SNP/Greens, but not for the most part robustly on the side of common sense.