Like we did with Lightning nodes? No, it will not work. This has been the daydream of technologists since when NAT was invented and they realized the internet was not as decentralized as they thought. Look at the amazing number of "self-hosted" collections of software and guides that exist and have existed for decades, and yet only 12 guys do it. I think it's good that we can do it and I hope more people start doing it, but running servers is too complicated, even for me, and the goal of Nostr was to make a thing that would work without requiring people to run servers.
Discussion
you need to do some work with wireguard tunnels, then you'll see that while it can't be perfectly decentralised it can still be greatly distributed
i'm using this tech on a daily basis and if you use an outbox client you will literally send your reply to this message to my relay via my reverse proxy and wireguard tunnel
it's really not complicated, i'm running a git host on my mini pc using a cheap VPS that cost me 35 euros for a whole year with a reverse proxy that i modded to do nip-05 and it routes inbound traffic to domains and subdomains to endpoints on a wireguard subnet
it only takes me about an hour to set this up manually and i can imagine writing tools that automate it and then add a shopfront and account management interface for the service provider and integrate a wireguard client into your client interfacing, with a handy simple installer that just makes it work and all you have to do is direct it to your host with your npub and voila
and yes, the point is that because the asshats at the IETF etc and all the big telcos who want to do their service as faux internet providers for the Con don't want people hosting their own services they have been marketing this snake oil for decades and never do anything about it
but wireguard+dns+reverse proxy does all of that and the centralisation is only small compared to facebook or twatter