Prince Andrew will reportedly not have a ceremonial role in King Charles coronation because he is not a working royal