I agree with almost all you’ve said, other than Flynn getting egg on his face. I can’t see that.
From a purely political standpoint, the SNP getting sidelined even more is probably great for the SNP in making soft No’s consider their position - “look, they just don’t care about Scotland”.