On paper, he is winning hearts with stoic duty and foreign charm offensives. But behind the scenes, British public opinion has cooled to levels not seen since the final months of Queen Elizabeth’s reign. Senior Editor Jack Malvern breaks down the numbers – and warns of a potential storm ahead