Andrew Lownie’s minutely detailed account of the Duke of York’s disgrace and downfall achieves the near impossible