Could try Spy x Family. Still action, but less explicit in its depictions of violence (though there is still violence), and overall wholesome story / message.

I do think that content creation would still continue but have to find alternate sources of income- many of which already exist for other mediums. Integrated ads will probably still exist, Patreon or similar systems will probably become more and more common, and I would assume any new spaces could also integrate something similar to Twitch Subscriptions or YouTube memberships.