>Luckily, society broadly creates more than enough wealth and resources to provide for you, even when you are disabled or elderly.
I see no evidence to indicate this. Societies do not exist in a vacuum, they either need to import resources, or they need to defend against invaders. Therefore, the more resources that go to the non productive, the less resources there are for importing and/or defense.
Importing also includes quality of life for young, productive people, as they usually aspire for material goods rather than living life solely for the purpose of servicing the non productive.
Having large portions of society not be productive for decades, even requiring large amounts of manual, highly educated labor to sustain them, may very well cause discord and decrease global standing. Demographics and the shape of population histograms affect inputs and outputs.
The simple evidence of my claims is the continual decrease of Social Security benefits. A simple monetary wealth transfer, easily comparable over time periods, is unsustainable due to increased longevity and lower total fertility rates, resulting in multiple cuts to Social Security benefits. It is common knowledge that people paying Social Security taxes now will receive less benefits.
https://www.ssa.gov/oact/progdata/nra.html
Even the UK has quite the political conundrum with needing to get rid of their "triple lock" pensions, but not having the political will to do it.