Getting results, short term, isn't being an effective leader. Effective leaders do what they say and don't take insane risks that have no way of paying off.
He's been leading SpaceX from success to success for 20 years now, or a quarter of the average American lifespan, a bit absurd to suggest that's "short term".
Getting things done != leadership.