I suspect Cao is going to be removed from D&D shortly.
Just a feeling or something more?
If he was responsible for this whole debacle, then it's possible Hasbro would let him go, but then they might have to rethink the strategy he has been putting in place for the future of their IP.
Unlikely. If they do, it represents a repudiation of the strategy he's been pushing, and an admission that they goofed. And upper management HATES to admit they fucked up.
Still, this IS clown world, and weird things happen every day.