I only had one offer of working at a company with a pension program. The recruiter highlighted that the pension "existed" but was unlikely to pay out for a new employee.

I knew someone who was close to hitting their 20 year pension in the private sector, but the company instead decided they had a performance problem in year 19.

While the federal government has less incentive to play such games, betting on illiquid financial offerings that are contingent on a single entity liking you for N decades and still being around after Y decades is pretty suspect.