It’s certainly hard to argue that Scotland shouldn’t be allowed to hold a referendum again. Usually I feel that the one they had a few years back should stand but with brexit the situation feels sufficiently changed that the old result feels dated.
But at the same time, the lesson should be that a simple majority is not a sufficient result. Either a qualified majority of some sort, with minimum participation threshold, or maybe two referendums with a general election in between sounds about right.