Detroit is not alone. A CNBC analysis of more than 120 of the nation's largest state and local pension plans finds they face a wide range of burdens as their aging workforces near retirement.