I'd put key emphasis on the "little" part.
The reasonable man adapts himself to the world; the unreasonable one persists in trying to adapt the world to himself. Therefore, all progress depends on the unreasonable man.
-- George Bernard Shaw
I think there's a lot of truth to this, but the key is you can't be too far out of touch with reality either for your ideas to be impractical or to attract and keep the people around you needed to implement your vision. So, if you start out being just a little unreasonable, maybe that's fine. However, veer too far off into the weeds and you fall out of that "sweet spot". I think that's what's happened with Musk. However, he currently has too much money and power for people to completely ignore.
Past performance is no guarantee of future success.
Based on its financial performance, Twitter/X has been an utter disaster. The main reason it hasn't failed more catastrophically is that there wasn't a direct competitor for people to switch to (but now
BlueSky is public, so...). Don't overlook the fact that he needed a lot of financing to make that deal happen, because very little of his assets are liquid. I think the train wreck we've witnessed is going to make future endeavors much harder for him to finance.
I think these things would've happened, anyway. Maybe just a little bit later. If an idea is good and remotely practical, it tends not to go unnoticed or unimplemented for very long.