I think the interesting data point is that 19% of leave voters would vote differently in hindsight, but only 5% of remain voters would. That's a 4x difference. But you're also right that most people did not change their opinion.
Like, the original thing you're asking is probably not very well understood or not very consequential if about half the population is for and against it.
You can absolutely make a decision based on this, but you're asking a whole bunch of "armchair experts" their opinions, only to find out that they don't know because they don't have a good concept of the suggestion.
So the change in opinions after the fact is actually probably a lot more meaningful than the original vote was.
51.89% voted for Brexit. That leaves 41.51% now.
48.11% voted against Brexit. If that hasn't changed, the British public no longer support the policy.
Can't help but feel people are citing democracy here when it aligns with them but otherwise they're scornful of the general public.
I think something of Brexit's magnitude should've required more than a simple majority of the population to proceed with.