So it was - but 2 of the 4 nations voted remain,
Nations had no vote. People voted.
That said, it is a nonsense to say the SNP couldn't have an opinion on Brexit just because it was a UK wide vote.
I'm sure you will appreciate that statements along the lines of 'the people want Brexit done' are utter nonsense: unless 'the people' is a term that applies only to leave voters
Which is exactly what Brexiteers mean by "The People".
On the bright side though, if Brexit does happen it will aid the breakup of the UK.
I think you are right that it will lead to the destruction of the UK, but it is not a bright side. You've seen at first hand the kind of chaos that occurs when a country leaves a fairly loose union that it has been in for 45 years. Can you image how much worse it is going to be to extract Scotland from the UK?