The government has no problem with programs producing tangible value that also cost lives. Consider the military, police, search and rescue, and really any activity where people do anything with nonzero risk. The lives lost are part of the cost.
Example: Astronaut Tim goes on an EVA to perform an emergency repair after a micrometeorite damaged the space station. A malfunction of his space suit kills him. Everyone agrees that Tim died a hero doing a high-risk activity that needed to be done, and almost no one would say it means we can't do spacewalks or can't send astronauts to space anymore.
Compare to Challenger or Columbia: The whole crew dies randomly on the way up or down during a routine mission. A program which became known for having like, a 10% chance of that happening would be horrifying (in my opinion).
But Shuttle was an economic as well as a safety fiasco. So there was no good motivation to keep using it.
The biggest tragedy of the Shuttle program was the 12 figure cumulative budget it consumed, equivalent to many thousands of lives.
Assigning a finite value to human lives (in the US, it's around $12M) is absolutely essential to evaluating policy tradeoffs.
> people are unrealistic about the value of human lives
Which one is it?
Given 2 is true and extreme, politics dominates all, and anyone acting like you would have been thrown out of political power as fast as possible. So no, "the cost of" does not pertain only to materiel and technical development, etc.
No, those are just par for the course, a necessary cost for a military that can deliver its intended function.
Manned space has the problem it was set up as theater, not to deliver value independent of the theatrics.
If a space program costs billions of dollars a year, but cannot tolerate any deaths, it should just be abandoned, since it clearly isn't delivering enough value to justify those billions of dollars.
Shuttle's real problem was it was just an uneconomical design. It was foolish to expect government and its cost-plus contractors to be able to optimize for cost.