Voters across the country spoke of familiar themes of doubt and disconnection – and a new, tentative belief in the future, says Guardian columnist John Harris