Striking the right balance could easily take 20+ years, but social media is here to stay.
What's more, media can then report "John Doe is allegedly a domestic abuser," citing the tweets as evidence that there are allegations that John Doe is a domestic abuser. You see this pattern with pizza gate (some dumb social media posts getting picked up by Republican news), and with Kyle Rittenhouse (dumb, false twitter posts picked up by left-leaning news). In the latter case, the news outlets have been getting sued for defamation because the reporting was damaging and so demonstrably false.
Section 230 protection for these platforms erodes all standards of truth for news.
You can of course sue for any reason but winning is another matter.
(It's easier if the defendant is not a public figure, but still, in general, it's relatively hard to win libel suits in the US.)
In fact IMO it's even worse - unlike newspapers which would at least be embarrassed by blatant mis-reporting, sensationalist and fantastical stories are a major source of profits for social media, and they've got incentives to encourage and promote them.
Yes, most mainstream publications do strive for truthfulness (fortunately) but it's not really a requirement for 1st amendment protection and I'm sure we can think of fairly mainstream news outlets that don't let the truthfulness responsibility cramp their style too much.
Ironically, given all his complaining, if Section 230 didn't exist, Twitter would have no choice but to ban Trump. He'd be an absolute nightmare in terms of liability.
Give enough people you agree with a platform, demote the ones you don't, and boom you've created a narrative without your hand putting pen to paper.
The only way to avoid this is to permit ALL content (which we have decided is untenable), or somehow precisely censor as much on one side as the other (which is impossible).
If one "side" is breaking rules about promoting violence, and the other is not, they are not being censored or repressed- they are just breaking rules and their content will be removed.
In the US we seem to feel its ingrained that there has to be two (and only two) binary "sides" in opposition to one another. This is the minority case around the world. Things get a lot thornier when you have a whole bunch of different sides that tend to be focused around a narrow view of issues.