The tide’s been a turning since Edward v111, Diana , Andrew , Queen Elizabeth’s death yet ……. They are still here and crowds still greet them
Edward8 and even the Diana debacle took place in a far more deferential and less scrutinised age.
Of your more recent examples Andrew's caused immense damage to the image and in the process turned an unwelcome spotlight on their privilege.
The dust is yet to settle re. QE2 but there's a welcome increasing awareness of how she manipulated the system to royal advantage.