Civ7 I think goes downhill very, very fast. And by modern if is probably the worst Civ game in the franchise. While for me Antiquity is the best civ experience ever produced, it can't hold the entire game on its shoulders, and overall, the monkey paw curled on the devs hard.
However... I don't agree with your argument in the slightest.
The devs have gone over the logic of everything they wanted to achieve and why their decisions led to one another... And as much as I think the end product was a mistake, I can understand why they went down each step in turn and it makes sense.
I believe the most prominent comment about player data specifically was about how many players were finishing games. In isolation I don't think trying to get players to play all the way through a Civ game is a bad goal... And I understand for devs - if you are making end game content and most games never get that far it's got to be somewhere between disheartening and frustrating.
So, while Civ7 is so far not living up to its promise, I find it difficult to say that the devs made illogical decisions. Each individual step in their thought process as described makes sense, it's just that the combination is not great.
Ultimately I think they underestimated how much of the audience get turned off by having stuff taken away (ages & civ switching), how much a lot of the audience identify with their civ and use that as the identity of their game, and then built a game design which requires curtailing snowballing - only to find that for a large amount of the playerbase the snowball is the game.