We're still fighting a lost referendum from nearly 5 years ago? As much as I didn't like the outcome... it's gone!
I think your 2nd from last para is instructive, "What does this type of democracy prove? That people aren't very nice when you give them an anonymous ballot? that too many are simply too stupid to have their own opinion and that some are clever enough to manipulate enough people to win elections."
If the referendum had gone the other way, would you still have written this?
What the referendum showed, like with the Trump result in 2016, is just how out of touch the elites and the progressives - myself included - were with the baulk of voters who felt lost and left behind by the tide of globalisation.
People weren't stupid or mean, they were pissed off. And when we understand the reasons why people voted for Brexit or Trump then the left can begin to build an actual alternative.
Until then, it's gnashing of teeth and pissing in the wind.