An ex-royal staffer gave insight into what Prince Andrew is really like behind closed doors.