Think the only ones who see the profits vis a vis NASA are the companies that actually build the stuff for them
And the employees working for those companies, who in turn spend the money buying goods and services from other companies.
Not to mention the eventual commercial value of any new technologies which are developed along the way. That's sure to be shared by a broad cross-section of companies.
Pumping money into NASA pumps money into the economy just as well as anything else.