Anecdotally, I know many a kid who has taken an interest in space and rocketry after watching a SpaceX launch.
What empirical data have you to show that there is no correlation between space awareness (whether by Musk or anyone else) and STEM enrollment?
I was personally inspired to go to physics partially because of my love of sci-fi and all space related. That's completely orthogonal to the skeptical sentiment or lack of moon landings in my lifetime.
Real "space awarenes" comes with facts, not with hype. You can drive only so much motivation from outside.
It's the frequent meta comments like dimillian above about "hate" and "negativity" that I find negative and harmful. They try to steer the tone of discussion to direction that the commentator feel more comfortable with.
Wanting protect feelings from getting hurt even in discussions related to technology and science are absurd.
'Say only positive things or the fragile Mars mission will collapse.'