Social security taxes explicitly pay for the current generation of retirees. it's not a pyramid scheme (how would that even make any sense?). The "trust fund" is running out of money but that could easily be solved if we were willing to tax the rich, corporate profits, and capital gains, at higher rates or more aggressively (that is not allowing corporations to escape tax so easily). Or we could continue to fund it at a deficit. But, again, it's not a pyramid scheme. That doesn't make any sense.
I think the person you were responding to meant ponzi scheme, not pyramid scheme. The first sentence from Wikipedia sounds quite similar to SS
> A Ponzi scheme (/ˈpɒnzi/, Italian: [ˈpontsi]) is a form of fraud that lures investors and pays profits to earlier investors with funds from more recent investors
Just replace investors with tax payers.