The SpaceX founder told the memoir’s author that he is often a ‘fool for love’