Sir Clive Alderton, King Charles' senior aide, will resign next year, marking a significant moment in the strained relationship between the monarch and Prince Harry.