In the early days of the rocket program in the 1940s, there was a lot of failures leaving nothing but a pile of rubble each time. By the time all that research, equipment, and people reached the US and Russia it still had a long way to go before 1957 when the US began using Atlas rockets that were reliable as launch vehicles. That was all done in real time with real physical equipment. Some of it was driven by the endless, at times, mindless need to outperform "the enemies" technological advancements.
While we might like to think that we have advanced to the point where we can model anything we want in a computer, lay out a design, then build a ready to go working unit, we are not there. Things that look like they work, but have far less physical impact, seem to pass the test of use, are not pushing the envelope like a 5,000 ton 400 foot rocket does.
We are spoiled by the imaginary visions of huge dry docks housings lots of Enterprise size spaceships. Ideally the big space ships need to be launched once and left docked in space. We build big ocean going ships and then leave them docked in the water, we don't drag them back onto dry land in between voyages. Bringing the big spaceships up and down over and over again, with gravity tearing at them and all that stress from the rockets, the only thing they can do is eventually break. Eventually we will have designs and materials that can take any kind of stress, but for now that is not the case. All of which makes it even harder to build a huge spaceship that works.
The top level people can be nuts, probably are, and maybe its unavoidable, but so long as they provide the materials and can find people willing to do the work, it is the hard relentless work the workers do, which makes the dreams of the crazed industrialists come true.
As far as fixing problems at home first, that's never going to happen because nothing is done that way. At the same time, until the space programs start bringing back useable materials that make a big difference for life on Earth, they need to supply information, free research, and designs that make things work better on Earth now. Perhaps the satellite industry will be what makes space exploration not only practical but necessary. Its all in space but the benefits are all used on Earth. Launching drones from Earth to do space work is not practical, nor is a completely automated spaceside drone service operated by remote control from Earth a workable idea. Eventually there is going to be a satellite maintenance/repair/replacement service that requires people operating in space, even if they are only operating remote controlled drones to get the work done.