John McCain was ‘appalled and embarrassed’ by Meghan McCain’s tantrums, former campaign manager says