I can definitely empathize with that, I'm happy with what's being achieved as well. Seing how SpaceX and Tesla are routinely achieving their goals and arguably change the world, I often can't get over the fact that the output of our civilization seems to hinge on the iron will of a few billionaires.
Elon Musk (and SpaceX as his tool) is just an extremely illustrative example of this, because we can directly see what our space capabilities and ambitions would look like without him.
I wish there was a Musk-like figure focused on transhumanism, but sadly it may genuinely be too early for that in my lifetime. Or not. And that's the frustrating thing: we wouldn't know until one appears.
I know this sounds like I'm writing a love letter, but it's really not meant that way. I would rather live in a civilization that has its own momentum and a better-distributed capacity for achievement, as opposed to putting my hope for the future on a few tenuous human pivot points and their whims.