Analysis: the Queen’s support has been clear but the court of public opinion is unlikely to exonerate the Duke of York