I have never turned on the animated day/night cycle in 4000+ hours of playing Civ VI.
I have also never turned on the day/night cycle in the game Anno 1800 despite 2000 hours or so in that game - even though some really beautiful screen shots can be produced in both games using the night part of the cycle.
That's because the night part of the cycle in both games Detracts from gameplay: makes it harder to see what's going on and what you need to react/act upon. Except for setting up purty screenshots, it is a Negative Influence on the game play - at least, on My game-play, which is, frankly, all I'm concerned with.
So, if they want to attract to the purty screenshot crowd, by all means include it, but also include an Optional version, and it will remain gathering dust in the bowels of my computer for as long as I play Civ VII.