Queen Elizabeth 'loved when things went wrong,' long-time staffer claims