http://en.wikipedia.org/wiki/Ponzi_scheme
Insurance is not a scheme "destined to collapse" when it runs out of new investors. Insurance is perfectly sustainable. In fact, some of the oldest companies in business today are insurance companies.
Social security is currently "designed to collapse" as the trustees report has warned for years. The program will run out of money sometime fairly soon unless the benefits are cut or the taxes raised. In fact, it has already collapsed several times and a new program has been reinvented, also named Social Security. Initially the payroll tax was 1% and the benefits constituted enough to live on.
On your last point, you're simply making that up. Assuming you live long enough to reach retirement age, you will get benefits. The idea that you won't get benefits is based on absurd projections that wrongly assume the retirement age will never change. That's simply not going to happen, benefits/age will simply be adjusted to compensate and keep the program for those within a few years of the average lifespan, as it was intended.
You've fallen for political scare tactics of those opposed to the very idea of social security because they're opposed to all government assistance and anything even slightly socialist. Benefits simply have to be adjusted so payouts don't exceed payins and we're not using debt to support people. For the boomer generation, that sucks, because they're huge and gen X isn't. For gen X, that's great, because they're small and gen Y is huge.
No it wouldn't, your concept of pyramid scheme is flawed. By your definition, all insurance is a pyramid scheme. Pyramid schemes promise everyone they'll get out more than they put in and this eventually collapses. Social Security makes no such promise, it's insurance, they fully expect many people to die before getting out what they put in or even starting to get anything out at all. That's how any insurance works. Social Security is not a pyramid scheme.