What you’re asking is akin to: why are people impressed by the airplane? We’ve already reached the Americas and India by boat.

SpaceX, and others actually are not advancing science per se, but are greatly improving/optimising the engineering so that it can be used in cheaper ways by others.

There’s also the issue that after the moon landing we didn’t really improve that much and much of the knowledge faded