Pension isn’t about money. It’s about work. Less working adults => less surplus value created by society => less resources available for retired people.
How you finance that - via direct payments / taxes, or via individual savings - is besides the point. Neither of these can defeat the economics of supply (of working-age adults’ labour) and demand (of the retired non-producing population). If you try to force it, you’ll just cause other issues (e.g. housing / market crashes caused by all pensioners cashing out at once, or wage/food inflation caused by labour shortages).
Pensioners don't cash out at once. The number of pensioners grows slowly which many result in gradually lower demand for stock or real estate. No need to expect a crash because of this.
No need to expect anything to happen to food either. Food production is highly efficient and relies on only a tiny fraction of the total labour
Blindly investing and then assuming that it still has value when you retire has a lot of risks. This sometimes happens with owners of small shops who hope to retire with money they get from selling the shop.
So you need a pension system for a population that doesn't grow. Basically that means that everybody has to pay for their own pension. It doesn't really matter whether you do it as taxes that get paid to the people currently retired or by saving money.
The solution The Netherlands came up with (next to moving to an individual pension system) to try to raise the retirement age to 67. This is quite unpopular. But it's either that or a low pension.