The England football manager once derided as ‘woke’ and ‘soft’ has succeeded where his predecessors failed, says Guardian columnist Jonathan Freedland