99.9% of the nodes on Bitcoin network have OP_RETURN filter with less than 83 Bytes. Bitcoin works well. Is the network harmed? I don't think so.
Is the network now censorship resistant with the filters? Yes. Will it continue to be censorship resistant? Yes. Also, its a monetary network. Bitcoin is Freedom Sovereign Money.
I do think that CSAM will harm the network.