The solution to this in my mind is self-hosting. Yes, right now that's the exclusive domain of tech nerds, but in theory there's no reason that an open source project can't come along and make this relatively easy for non-techies to set up for themselves (in a similar way to how, say, Squarespace made website creation easy).

I think the real hurdle in adoption would be that most non-techies don't even register their dependence on big cloud providers as a problem yet. But I expect the day is coming. Similar to how Mastodon saw an influx of Twitter users when Musk announced he was intending to buy Twitter.