Andy Burnham's push to reverse Brexit is a stark reminder of why millions were desperate to leave the EU in the first place.