Then-CIA director Gina Haspel said Trump’s post-election behavior was ‘insanity’ and he was ‘acting out like a 6-year-old with a tantrum,’ book says