For years, the Duke of York’s monstrous behaviour was shielded from the world – but the intensely private and upsetting revelations in a new biography cannot be the start of a public rehabilitation, says Harry Mount