Considering he was in favor of remaining and he promised a referendum because a large enough proportion of the population wanted to voice their opinion on the subject, I don't think he was the right person to negotiate the terms of separation.

Then again it was non-binding so instead of promising to just go with whatever the population voted for he should have promised to negotiate the terms of separation and then hold a second referendum to know if people agreed to those terms or preferred to stay.