There’s an entropy factor involved though.
It’s easier to destroy things than to restore them.
We, the UK, will never be able to rejoin the EU on the same sweetheart terms as we had previously. That’s gone and can’t be replicated.
In much the same way as those campaigning for Scottish independence continue to campaign forever no matter how many referendums they loose, no one will be able to recreate the UK if they succeed.
You need the thinest majority to win and you can keep campaigning forever.
Which is why there was so much outside interference and breaking of the Brexit campaign rules. No matter the cost it can’t be reversed.
> It’s easier to destroy things than to restore them
No such rule exists. Historically, it's been almost impossible to remove any piece of regulation or bureaucracy once it has taken root. Radical dismantling of institutions is a rare thing. That's the same for public services or, say, chat control. I did not expect Brexit to succeed: in fact it only happened because David Cameron had a whimsical moment of fairness and respected a referendum result, against general expectations since he had nothing to gain.
Looking back up the thread, we're equating nagging to construct something (chat control) with nagging to dismantle something (UK EU membership). And I suppose Scottish independence would have aspects of both construction and destruction. The pernicious things that are hard to change are attractive-sounding policy ideas, whether they build up edifices or tear them down.