Yes, and I think this is the key point that perhaps bridges the gap between what I've been saying about my experiences, and what @RobertBMarks has been saying about his.
There's a difference between a corporation shoehorning a few weak token gestures of "diversity" into a work that isn't in any way focused around or created by marginalised people, and an independent creator from a marginalised group or dedicated to sensitively depicting under-represented people in genuinely important, pivotal story roles in their work. It's like how you'll see LGBTQIA+ people rolling their eyes at brands making their logos rainbow coloured during Pride Month, while homophobes also get angry about it; it might seem to point at "nobody wants marketing based on diversity", but it's more like "queer people want to be actually supported and protected, not profited off by companies that don't actually do anything but make a token gesture".
This is why Robert is seeing trends going one way so it seems like it isn't working out... while meanwhile at my day job in kids media, I'm developing diverse kids shows with diverse creators, because there's absolutely a ton of demand for diversity in children's books and shows right now.
There's a big audience for diverse content out there, but it has to feel authentic or you'll both piss off people in the "anti-diversity" crowd AND leave the pro-diversity crowd feeling uncomfortable with a weak token gesture or a depiction that's actually insulting or stereotypical, or even feeling like you're capitalising off marginalised people whose own work you should be signal boosting rather than telling their stories for them.
Lefeu in Live Action Beauty and the Beast is a prime example. Homophobes hate that a gay character got put into a movie which never had any canonically confirmed gay characters before, and gay people hated that of all the characters to make gay, they picked an incidental minor villain who's name means "the fool", and who exists to be a simp for the main antagonist, and then made the only hint about it one scene where he briefly dances with a man (ie. something you can erase for the countries that don't like it easily). This isn't a depiction anyone would have wanted, really. If they'd actually had some guts and wanted to go for more than just a token gesture, they should have made Cogsworth and Lumiere a couple or something. Rise of Skywalker is the same. A pair of ladies kiss in the background of one shot and Disney want us to give them a damn medal or some crap even though what everyone I know in the LGBTQ+ community actually wanted was Finn and Poe to be a couple, which would have actually taken some guts and been a big, brave gesture worthy of the praise they wanted.
Ultimately that's the deciding factor to me. People want content that reflects their experiences, or they want genuine support of marginalised people to a level where it can't just be quietly edited out. When somebody makes a fuss that their work is diverse but doesn't follow through, it's going to piss off both the people who hate even just the idea of diversity, AND the people who see a lacklustre attempt that in no way sates their hunger for representation but still an expectation of praise and money for it.
