despite all this an amazing number of artists and authors have become wildly successful. and a lot of them are very good. you can worry about your own potential career all you want, but don't make it sound like this is going to prevent all art going forward. it's never stopped it before.
All art would not be prevented. That is hyperbole. I think that some people are underestimating two interrelated issues.
A. Chilling Effects.
This is a commonly known issue, and why (in most Western countries) we try to have expansive protections for free discourse. It's not just about the art that gets banned, or removed, or suffer commercially, it's about all the art that doesn't get made because the artists do not want to worry about those issues.
Since we are all alluding to Hamilton right now, most people in life are Aaron Burr ("Smile more, Don't let them know what you're against or what you're for"). If you want more and better speech, you need to worry about chilling effects.
B. Barriers to Entry.
Cultural consultants are a great idea! But when you think about it, you realize ... wait, they have to get paid. Right? And who is going to pay them? For a big Hollywood production, it's not that big of a deal. For a huge company like Hasbro, it's a minor thing. But what if you're a small company in the TTRPG space? What if you're a solo designer that works on small (or negative!) margins? That's a massive added cost- or, put another way, that's a cost (a "barrier to entry") to publish that kind of material.
If you publish something that doesn't need a cultural consultant, then you're fine. Which means that suddenly materials that tackle certain subjects will most likely only be undertaken by those that can afford to do so.
I don't want oversell these issues; great artists have worked under much more stringent regimes (in fact, art should provoke, shock, and offend). But assuming that there is no cost or effect of this isn't correct either; there is no such thing as a free lunch.