Scottish independence is not a certainty by any means for reasons given above....and nobody in Parliament has any inclination to endorse another one anytime soon. Sturgeon is swimming against the current.The Scots seem to universally hate Johnson and the Tory party, they don’t want to be represented by right wing populists.
But Tories won’t be in power forever and Johnson certainly won’t, whereas Scottish independence is not easily reversed.