If you check the modlog, you'll see posts that have been removed by the mods (great job mods, btw!). However, you can still click into the post to see it - benign example here: https://lemmynsfw.com/post/95856
This means that, even though the post is more difficult to find now, the server is still storing and serving the content.
If that content ended up being CSAM, it needs to be completely purged; otherwise, the server ends up distributing it but you need to know the link, which is trivial.
Does Lemmy provide a way for mods to fully remove a post from the server and cache altogether? If not, this feels like a nightmare situation waiting to happen. It's then also a very scary attack vector.
Maybe it's only still there while it federated out a delete command?
I would imagine that deleting CSAM content without reporting it to the police would be a crime by itself, so taking it out of the feed only might be the intended behavior? Then though, you'd still expect some mechanism to force a delete (either once you've been given the legal go-ahead or if the material is just generic garbage).
Definitely something that warrants an official answer. Likely just something that the devs have for debugging and forgot about would be my guess.
There's a "purge post" button, which seems to actually remove content or access to it. I didn't try it out yet, because there wasn't a lot of moderation necessary so far, to be honest.