He is doomed to failure, at a time when his party are losing thousands of members and popularity is on the wane. A large proportion of his own party see him as a liability. His previous posts in government haven't exactly been great achievements.
He has said he wants to 'Break up the United Kingdom in anyway he can'
If that vitriol doesn't confirm the SNP are more about hating the rest of Britain as a whole entity, rather than seeking an independent Scotland to work alongside Britain as friendly neighbours, I don't know what does.