Once celebrated as a decorated war hero, Andrew, the brother of King Charles III, has been thrown into the royal wilderness.