Good bit of survivor bias in the retired population. If you can put in 30-40 years of full time work and then afford to retire you probably don't have a propensity for substance abuse.

You've clearly not been hanging out with French retirees.