Shifts in geopolitics and domestic politics have made a big difference to how Britons feel about Brexit. It is a good moment to consider where relations go next