The Brexit referendum shouldn't get a special "do-over". Instead, the result should be ignored because leaving the EU is a bad idea regardless of the people's will.
I'm sure a majority of the people have many other terrible ideas that they agree with, especially when you only need 51% of those who care enough to vote to constitute a "majority".
Trusting the will of the people is the philosophy of a lynch mob, not a government.