Charles Spencer’s memoir revisits the events surrounding his sister’s death, her funeral and the years of tension between the Spencers and royals