In the end, it takes the efforts of millions of people (they're called taxpayers) to put three or four people out there. Going to Mars would require a phenomenal budget, and I suspect we'd find rocks. Considering even the closest star would require multigenerational commitments, and generations would be born and die on that ship and on earth during one trip. I can't imagine the real Space Family Robinson. We've got a reasonable idea of what's in our solar system, and the next step is a doozy, with no real reason, other than we'd like to go.
I don't discount scientific research from space exploration, but no one's made a compelling case as to how this would affect us.
......I suspect we’d find rocks....
The fact is, we don’t know what is to be found. The term rocks is being used as anything that is solid. What is important is more specific, the compounds that make up the solid.
There has been a lot written on the subject but I recommend “The Moon Is a Harsh Mistress” by Robert Heinlein. He explores concepts of moving stuff about.
To many the concept of living with uncertainty is intolerable. For others the uncertainty of what lies ahead is what makes life worthwhile. Uncertainty is the reason for exploration at Yellowstone, in a cave, under water or in space.