UK royal aide apologises and resigns after making racist comments