signing into cloud services and downloading apps is just so much easier to do!
This is actually true, but it doesn't speak to why self hosting is "impossible" and more to how the lack of education around computers have reached an inflection point.
There's no reason why self hosting should be some bizarre concept; In another reality, we would all have local servers and firewalls that then push our content into the wider internet and perhaps even intranet based notes. Society as a whole would be better if we chose to structure the internet that way instead of handing the keys to the biggest companies on the stock market.
I'll give this podcast a listen to though, as it might be interesting. I think the reality is that some more docker frontends might help casual users jump into the realm of self hosting -- especially be setting up proxy managers and homepage sites (like homarr) that work intuitively that never requires you to enter ports and IPs (though fearing that is also an education problem, not a problem with the concept itself.)