Quite a few of my parent's friends and my relatives were professors of this and that. I thought they were the coolest people ever. They were so much more interesting to talk to and came very close to inspiring me to an academic life (the path not chosen for me). But in all those cases they fit that classic profile of having enough money to have the Volvo, the good house, and quite a bit of travel.
But if they had been forced to live like grad students I can certainly say that I would have been far less inspired to follow in their footsteps. While I didn't take that path, how many people who would are being dissuaded now?
I have a simple view as to what the problem is. Science money has two serious political problems. One is that it takes longer than an election cycle to create result, which themselves are often not initially sexy (think of how unimpressive the initial quantum discoveries were, but how much impact they eventually had). Also science often involves giving money to groups of already employed scientists who then spend the money in a myriad of different ways. Whereas giving money to a military contractor provides a bunch of fairly blue collar jobs and loads of kickbacks from the companies.
But even worse this creates a feedback circuit. If you are a math whiz and are looking at your various options then business school should be a snap. Then you can follow in the footsteps of the Ferrari driving cool kids on Wall Street. If this actually works you will inspire another generation of whiz kids to follow you. But quite simply few nations can build greatness from banking. There needs to be something to bank.
Basically if you go to most schools (especially impoverished ones) and ask the kids what route would you recommend for becoming really successful they will first say sports star, then rapper or other entertainer, and then things like banker, doctor, or lawyer. But engineer, scientist, inventor, or even building a manufacturing business just won't be on those kids minds.
This is well emphasized when you look at the classic map of top paid collage official in various states and it is almost always a sports coach.
The crazy thing is that a few schools have managed to master that connection with turning students/professors into businessmen and they are mindbogglingly successful. Not that money should be the only motive for science at least if there is some there it will inspire generation after generation of people who will propel civilization forward.