I don't think moderation has changed at all. I'm not in the gore-y scene but I wouldn't be surprised if it has always been on Twitter, just marked as sensitive. Most social media sites have that 'dark reality' content scenes.

Same goes for NSFW stuff, that stuff has been on Twitter long before Musk bought it and it will still be available just marked as sensitive (like it always has). I doubt they will go the Tumblr route and kill a giant part of the userbase.