Fiscal confidence among city finance officers is plunging as COVID-era federal aid winds down, a National League of Cities survey found.