I guess it's easy to stick to the tabloid-version of monarchies when you don't live in one which would explain why C&C don't appeal to many - unless you actually follow the BRF for a bit and see that unlike W&K they actually work quite a bit. I think that's why many have come to accept Camillia at least.
When mainstream channels in the US, for instance CBS is planning a Prime Time special anchored by Oprah buddy Gayle for two hours to commemorate Princess Di's life and legacy it does become more than the tabloid version of the BRF IMO. Princess Di is like Marilyn Monroe or JFK. She will always be idealized vs reality because of dying young and tragic even if she was flawed. But she was the innocent victim in this sad triangle. She was the young bride who was made a virgin sacrifice to appease the POW and the BRF who wanted heirs, a POW who was spineless not to stand up for the love of his life and made her his mistress. While the mistress enabled it and chose another innocent victim in her husband. This might have worked in the court of yore but not in the modern age where monarchy is no longer revered or even thought of as necessary.
Prince Charles may do all the work he can assisted by the Duchess and they do good work but they are also these people who because of their choices to be together brought 2 innocent people and 4 children into it and their lives were impacted to various degrees because of it. It's not the tabloid version of the monarchy, it is reality. You cannot work it away especially if you are to be the head of the church of England. Princess Diana will always be the shadow that hangs on the BRF and consequently protects her sons especially the elder from his antics. What will break this is if William was shown to be actively cheating on Kate. No mere dancing or holding a waist. But an actual proven affair. But Kate is no Princess Diana, she will not call the media and so the BRF is safe while Prince Charles will always be the man who cheated on his beautiful wife in the eyes of the public in not just Britain but in many parts of the world. It is what it is. Charles and Camilla did get married eventually so I hope they are finally happy for the price many people paid for that happiness is quite a bit.