The fediverse directly helps with that exact problem by allowing actual instances to remain small as needed. There’s no requirement that an instance have millions of users, which is what drives up cost. Personal instances can still participate in all other federated instances’ communities.

Mastodon has been a good Guinea pig for proof positive the model can work, with something like 4 million+ active users.