Make no mistake, if a company or institution isn't trying a lot and failing a lot to achieve a new type of goal, it's also not making much progress toward any new type of goal.
Regarding technical innovation, NASA did a lot of that in the 1960s. There were a lot of failures then (Mercury and Gemini programs), followed by incredible success (Apollo program). NASA's work with SpaceX is another great form of innovation -- pick the most innovative commercial partners and move forward.
"This is but one of many genuinely shocking aspects of NASA's decision a week ago to award SpaceX—and only SpaceX—a contract to develop, test, and fly two missions to the lunar surface. The second flight, which will carry astronauts to the Moon, could launch as early as 2024."
https://arstechnica.com/science/2021/04/five-reasons-why-nas...
I do wonder, however, where NASA would be if they would have continued with the DC-X prototype instead of abandoning it when it had a landing leg failure causing it to topple over in an early test.
> people continue to believe him for some reason.
I believe in him, and the reason is obvious. He gets things done nobody else seems able to.
Failure during research & development isn't necessarily a bad thing.
I'd recommend people to look up into those previous failures (and SpaceX is finding "new ways" to fail)