This claim is dubious. That you can sell people space exploration by hyping it up.
It does not show in money, or people going to STEM field. It probably increases interest for scifi books or videos.
> I'm sometime very tired of the pessimist sentiment here.
You want to be inspired/entertained as a consumer. People who must be constantly emotionally propped and mentally supported are not the ones who are willing to go and work toward Mars.