We associate the word 'art' with positive connotations and 'censorship' with negative ones, so I feel like a lot of us have the instinctive reaction of 'no, art should never be censored!' that we wouldn't otherwise have if it were phrased differently ^^; But yeah, it depends on what you count as 'censorship' - and I don't believe art (however you define it) should be given special treatment above any other forms of information.
I'm pro content warnings, like most people who commented this far. Some people say content warnings is censorship and bad for free speech, but I think content warnings can save free speech. We can apply content warnings liberally with little to no consequence if we go overboard and mislabel something (we can just unlabel it) - the same cannot be said if we destroy content that didn't need to be destroyed. If we label potentially harmful content clearly with the ways they might be harmful, then we don't need to destroy the content or prevent it from being created. It will protect information from being lost.
I'm generally against destroying content. I said somewhere else that I think all content should be allowed to exist, even if some of it should be buried under a mountain of content warnings, but on second thought I think there are some exceptions. If the content was created by harming real people, I think it should be destroyed if the victim(s) request it.
cw: pedophilia, CP
I'm against preventing people from or attacking people for creating content, as long as they're not doing something else that's harmful even if they weren't creating content. Exploitative photographs of real children should never be tolerated, even if it's just, say, from a nudist colony. If you want to make art of nude children, draw them yourself and make sure it doesn't resemble any real child you've seen.
Illustrated/simulated CP depends on what the science says about whether or not it makes pedophiles more likely to offend. I disagree with antis that say it shouldn't be allowed and anyone who makes/consumes it needs to kill themselves and it doesn't matter if they never hurt real children because it's still gross. But I also think people who say 'illustrated CP is okay because real children weren't hurt from making it' are being a bit irresponsible; we're just not sure what effects it has on people. Everyone's just shouting 'it causes CSA' and 'it prevents CSA' and I feel like both sides have an agenda. What does the science actually say? We need to study this WAAAAY more.
And by the way, 'pedophiles pushing the victim narrative for acceptance' is mostly about non-offending pedophiles who never want to hurt a minor (or put books featuring CSA into school libraries) trying to tell people they're not monsters because bad thoughts go through their heads. Even if you disregard the 'victim narrative' (honestly though, how would you feel if you were stuck with an attraction that's never okay to act on?), acceptance of them would allow more of them to come out to and let researchers and scientists study them, which will allow us to lean more about pedophilia. If protecting children is more important to you than hating on bad people, then you should support this.
Curation/what people allow in the spaces they control is a bit muddier, in a world where everything is owned by someone. In my ideal world, everyone will have a small space they have complete control over, where they can banish anyone for doing anything they find objectionable for any reason, where they can feel secure. And the rest of the world will be owned by no-one and anyone can say anything (provided they warn others of what they're about to say beforehand if it's something that could hurt people). But when all our public spaces are owned privately, 'their platform their rules' can very much end up being suppressive in practice.
For instance, I think nazis etc can have parades as long as they are surrounded by people holding signs that say something like (CW: nazism, antisemitism, homophobia, [whatever else nazis yell about at their parades idk I've never watched one]). Which I think by itself will eliminate harm caused by nazi parades just as effectively as outright banning them, because who's going to take them seriously with that preamble?