The silver lining on repealing 230 is ending centralization of internet into social media silos,
facebook-twitter-reddit-etc would not afford pre-moderating every single post. Pre-moderation of content is the only legal way for them
to exist and provide immediate 'dopamine' rush for posting content:
its a core mechanic of social media.
Its highly likely all video content have to be scrutinized by neural network to comply with SISEA+ unlimited legal threats from section 230.
Youtube will be a legal minefield and similar video hosting(esp. porn) will not survive(they don't have a fraction of Google's lawyers).
Once the section 230 protection stop existing entire internet will change: sites will have to really censor any bit of content and user-contributed content will be treated as site's own.
Ironically(until EU bureaucrats notice), EU servers will be freer for user-content: Facebook/Google/etc will likely migrate all datacenter stuff until EU harmonizes the laws with US(and where they'll go? Russia?)