They aren't entirely unsustainable. It's possible for them to be underfunded, but that's structurally avoidable if anyone was concerned.
> Any system that tells a worker they can work for 25 years somewhere then receive 25+ years of pensions at their inflation adjusted final salary is a crock.
Sure, but real-world pensions rarely come anywhere close to that; even generous ones are almost never fully inflation-adjusted (while COLAs are common, they are often capped at, e.g., 2% annually -- each year, not cumulatively, so they permanently fall behind each year inflation is above the cap) and they usually don't come anywhere close to 100% at 25 years. (I think the most generous rank-and-file current CalPERS plan is 2% per year of service at 55 years, which maxes out at 2.418% at 63+ years, and so would take more than 40 years of service to reach 100% of the base used for calculation -- which for employees hired in something like the last decade is actually the average salary of the last 3 years, not the last single year.)