I doubt it, not just because current social media sites are insanely popular, but also because there's a learning curve to using the Fediverse, and most people would likely find it complicated.
I made the decision to leave Reddit after Apollo was announced to be shutting down. I'll hang around until Apollo dies, but I'm already mourning the loss of niche communities. I can only hope that they'll be replicated here.
On the bright side, this place being smaller in terms of userbase makes it less intimidating for me to comment more often.