British royal aide resigns over racist remarks