When I first heard about the civ switching I was terrified, when I first switch about the radically different eras I was excited. The idea of historical eras being strongly different in mechanical gameplay and flavour, with a transition being a great shakeup, has fantastic potential. Sadly the terror was proven right but not the excitement.
You know what's the most depressing symptom of the game's state to me? Look at the discourse here, on civ reddit or on youtube. Or rather: look at the lack of said discourse. The vast majority of discussion on this forum is meta discussion about its survival and redemption. On civ reddit the majority of posts have barely few hundred upvotes and are similarly themed around meta criticism and apologetics. The civ reveals gather a pathetic amount of attention compared with the past games.
In fact, even the defenders of the games don't post much about their recent discoveries, fun, strategies or screenshots. I have a very good memory of a flourishing, lively forum discussions over the entirety of civ5 and civ6 lifecycle. Likewise, civ reddit has been super active during those game's lives, posting fun things from the game with thousands of upvotes. Even during the "drought" periods far from new content.
On the other hand, a shocking sight for me has been the great amount of harsh criticism and critical discussions the game has spawned on civ/reddit. I have disliked that place for years viewing it as very uncritical pale shadow of forum capable only of posting meme screenshots. Video game subreddits for some reason are more often too apologetic rather than too critical.
I retract my negative impressions of subreddit people, they have a strong positive bias but not rose tinted glasses. But for me the fact that even civ/reddit has little enthusiasm for the game is yet another sign of the crisis.
I don't thing the game shall be truly saved without the radical shakeup of a new direction by the devs, rethinking the fundamentals, reworking age system, partially swallowing the pride and admitting to the failure by enabling to old-style "perennial civs" mode, and going all the way to the revision of the DLC monetary policy and perhaps releasing some sort of "director's cut" for free. Perhaps this would even bring some changes in terms of leadership...