Late-Queen Elizabeth II's former aide resigns over latest racism row