This is actually  a two way debate if you ask me. If Bitcoin's core software starts censoring a specific type of data like CSAM I think it kinda forces developers into the impossible political role of global content moderators which  could compromise the network's neutrality.

Basically, attempting to ban easy to read data like that in a larger OP_RETURN will just push bad actors to use methods like scattering data across multiple standard outputs which in my opinion makes the chain harder for honest node operators to analyze and more resilient for the bad data itself.

If people are actually willing to pay the highest fees for block space even for arbitrary data that revenue kinda secures the network for everyone making a "byte a byte" to the system's security budget. Bitcoin's strength comes from its decentralized protocol and scarcity and not from trying to force human morality.