I wouldn't say it's because it's the "wrong" result but that only now you could make an informed decision because only now you can see what a Brexit looks like.
To be fair, it could be seen since 2016, but now it can no longer be honestly ignored.
I don't think we're seeing "what a Brexit looks like". We're seeing the fumbling of a government who gave the British people a vote in 2016 and whose bluff was called. They didn't want and, more importantly, didn't expect the result they got, and stupidly had done nothing to prepare for it. And for the last two years, they've petulantly gone through the motions of negotiating a deal that they would dearly love to fail. In light of all that, it's entirely unsurprising that the process has been a catastrophic mess. However, it doesn't give anyone the freedom to give up on what most definitely was a democratic decision.
I don't think they hoped it'd fail. There was no chance of anything better than the kind of deal Norway has - they pay, obey the rules and have no say - as opposed to what the UK now has - they pay, obey the rules and have a say.
A democratic decision on a poorly formulated question at best. Democracy assumes informed decisions by the people and this was anything but. The leave campaign made every misrepresentation they could in order to paint a rosy future we all knew would never be possible.
To be fair, it could be seen since 2016, but now it can no longer be honestly ignored.