You have to do something with your money. If you just stash it into a savings account you will literally lose money to inflation. A good mix of index funds (or target retirement-type funds) are probably the "safest" long-term savings you can do with your money.
You probably won't become a millionaire, but you probably won't be destitute either.
http://www.forbes.com/sites/thebogleheadsview/2011/01/28/thr...
Social security, pensions etc. - agree, these are on the way out due to demographic changes. But that's a point for individual retirement savings, not against them.
And yes, there is no such thing as stock performance prediction, this has been proven many times since the 1930s. So funds are useless in the long run - just a way to trade performance for risks, and pay a fee (while i agree that in the case of Vanguard, you lose almost nothing because the fund is really cheap).
If you bought the original djia in 1896 and were still alive you'd be very wealthy.
We used to think that all you had to do was work for a company for 40 years in the same job and you would be taken care of with your pension + social security. Pensions are just about nonexistent these days. Social security is going to be gone after the baby boomers suck it dry. And, personally, I don't have much confidence that blindly throwing my money into the stock market for 70 years is going to help me more than smartly saving my money. The current climate on wall street seems to be to rip off retail investors and take advantage of pension funds.
edited for typos..