The author of Revenge: Meghan, Harry and the war between the Windsors, said Meghan had been 'ecstatic' when first asked to appear on the cover of Vanity Fair's September 2017 issue