This will apply to any Scotland independence vote as well I presume?
That depends on whether, when Indyref2 occurs, as I hope it will, that there will be sufficient information available so that the Scottish electorate can be considered to have made an informed decision at the time, as opposed to the uninformed choice made in favour of Brexit. Those campaigning for Scottish Independence in future will, I hope, have learned lessons from the Brexit experience and that where the proposal is to change the status quo the electorate need to be fully informed of the implications of the change - and yes, having seen Brexit unfold I think that Indyref2 must involve better information than was the case in 2014, where looking back issues such as currency weren't well handled.
Of course we now have new information compared to 2014 that represent a significant change in circumstances for Scotland. In 2014 we were told, and by the same Tory PM who allowed the Brexit referendum to happen, that if Scotland wanted to remain in the EU we would have to stay in the UK, and that may have encouraged some to vote to stay in the UK so as to remain in the EU, and of course in 2016 Scotland votes by a notable margin to remain in the EU - and yet it is the very party who threatened that we'd be leaving the EU if we voted for independence that allowed this referendum and is now trying to implement Brexit (though the fat lady has yet to sing).
Just as a second referendum on Brexit is justified on the basis that the 2016 result occurred in the absence of relevant information then Indyref2 would be justified on the basis that there has been a significant change in circumstances, and especially if Brexit does happen: sometimes there is a need to revisit previous decisions if things change or new information comes to light.
Scotland votes Leave, rUk does something you don't expect, another vote will be fine?
That didn't happen though: but that isn't the main point about the weakness of Brexit for me. I'd say that if an uniformed decision is taken (on just about anything) and new information becomes available before the decision is implemented and finalised that describes in more detail the consequences of the decision, then only a fool would prefer not to reconsider their earlier decision: they may come to the same view of course, but they may not.