The new book Elizabeth: An Intimate Portrait revealed the late Queen may have had cancer