The opposition could still mobilise support for a people’s vote, says the Guardian columnist John Harris