I don't think anyone is going to argue that slapping expensive cargo onto a controlled explosion is the greatest idea, but it's certainly the only option that we presently have.
Ignoring manned spaceflight for a minute, the incredible discoveries and value that unmanned spaceflight have provided to humanity are immeasurable. A small list of examples of what we have achieved:
- GPS that can tell you exactly where you are down to a few metres.
- Weather satellites providing realtime data on natural disasters.
- Telecommunications satellites that allow for reliable and near instantaneous connection for people in remote areas.
- Telescopes that need to be in space to make discoveries like the confirmation of the Big Bang, the study of special and general relativity and the study of light in wavelengths that the Earth's magnetosphere protects us from. There are literally things we have confirmed and discovered about how the universe works that would not have been possible from Earth.
That's all from taking expensive equipment and slapping it onto a controlled explosion.
So yeah, it's expensive and dangerous, but the payoff has been huge. Seems silly to me to reflect on that and decide that it's not a worthwhile endeavor.