I think one thing the Sussexes and the Yorks have in common has been the focus on personal enrichment, rather than Royal duty, and this is I believe the main reason why people have taken against them.
Meghan Markle was never interested in the Princess role except as it pertained to her own personal advancement. The monarchy had simply been a vehicle for personal enrichment. She flounced off to America after a very short period of time determined to never set foot in the UK 🇬🇧 again!! Despite that she proclaims and exploits her royal title “I’m a Sussex now you know“. Even the Marie Antoinette style hostessing shows illustrate this misunderstanding. Rather than retire as a private citizen, she has constantly used her royal title simply as a way to make as much money as possible as she’s always been an “entrepreneur”. The rest of the title means absolutely nothing to her. It’s astonishing ignorance and entitlement really.
Fergie also did similar, in terms of her focus on money, once she became a non-working royal. However, at least she did not trash the monarchy, move countries, and call the UK people racist.
Although Harry is always proclaiming his royal status, the only thing he does now is Invictus once every two years the rest of the time it’s various lawsuits, demands for paid security and polo playing. At least Prince Andrew took his role in the Navy seriously.
Being a member of the royal family does give you certain privileges and entitlements, but you have to do something in return. If you want to retire as a private citizen, like Viscount Linley with his upmarket furniture business, as they need to make a living, that’s all well and good if you do this quietly and away from the main stage. Even Edward and Mrs Simpson retired to live a quiet life in France.
I believe it’s the vulgarity of using your royal status only for your own personal enrichment that sticks in the craw. People will forgive many flaws if you respect your own responsibility to your country. Ironically, their whole Royal status was cheapened in the process. The mystique and respect goes out the window pretty much. As the Markles have found out in California, where no one much bothers with them now. The “free lunch” is now just an up market burger bar in Montecito.