Re your last paragraph. You can, if you ensure it's not acrimonious. I do believe it will be worth it, you don't.
I respect your opinion, though I disagree with it.
The main demographic who want Indy in Scotland are young people.
I don't think I'll see it but will vote yes if we ever get the chance again. And we should, because it's democracy.
If the young people suddenly change their minds and want to stay in the UK, then I won't vote no, I just won't vote.
But I will leave it up to the people who will have have to live here long after me and make it work.
Hopefully, if we get another referendum, people won't fall out about it. I have never fallen out with my friends and family who voted no. There was no need for it. I still don't understand why people did tbh!