I don't know if a second vote is a good idea.
Imagine Remain would win: How many decades would we have to listen to the snark about "EU lets people vote until they are happy with the results!!!!11111". Let's leave them in their misery. Maybe they'll learn and be an example to other countries.