From my past experience with moderation on LP, I can assure everyone that Musk will be blamed for screwing up Twitter no matter how well he may run the shop. Basically, it comes down to it being free speech for HIM, not for the rest of the world. I expect he will do things much better than the prior ownership did, but many people will complain they can't post ABC saying it's because Musk is a tyrannical rat.
What is and isn't porn needs to be defined, but it can't be defined. Doxxing is a fuzzy issue as some home addresses can be found in the public domain. Threats are subjective also. I expect Musk will do a far better job and the change will be beneficial, but people will always complain.