The missing component in the above is making sure that one is compensated for giving their all.
Because there's a lot of things that are given up when doing that.
And ultimately, no leader is responsible for ensuring someone's compensation matches their effort. That's on everyone's own shoulders to demand.
And then d-day comes and it's over. The impetus is gone. And every single time, I try to hang on to it. I give myself new projects and fake deadlines. I force myself to get up early and stay up late, but the moment that magic is gone, those things become... work. And like I said, there are things I would rather do than work.
I think a lot of Elon's success stems from his mastery of this "lock in" phenomenon. He is (or at least was) able to induce it in himself to drive himself harder than normal people do. He is able to induce the same state in his workforce as by setting bold and inspiring goals and setting absurd deadlines.
This is not a secret, btw. Nobody goes to SpaceX without understanding that they're signing up to work double the hours for way less than double the pay. For many, this sounds like a nightmare. If you're a young single guy looking to lock the fuck in, to take on huge responsibilities and grow in the company of some of the smartest, hardest working people on earth, it sounds positively amazing.
tl;dr: It's a feature, not a bug.