What do you think the likelihood of a second EU vote occuring is? What good is a left leaning government showing positive results in the areas they can influence in Scotland, when people continue to attack them for things that they don't have any influence over? Not to mention the powers that are about to be revoked from the Scottish Parliament that were protected under EU legislation.
Nobody in a million years ever thought the YES campaign would get the level of support that they did. Almost everybody thought the idea of an independence referendum at the time was ridiculous, because there was just "no interest".
I'm not convinced for one moment that if another independence referendum was held that it would be a "no" result. So much has changed in so little time that it's no longer the same question anymore.