>Or a second referendum held once the terms of the actual withdrawal deal were known
Exactly, nobody voting for Brexit even knew what they were voting for! Many just had some nebulous, fantastical idea of independence from some "evil" organisation in Brussels.