Thankfully, there's a mod for that - and this one's from a developer at Firaxis. Civilization 6's cartoony vibe is all well and good, but when you've got an entire civilisation's worth of people resting on your every decision, a serious look is sometimes required.
I love Civilization 6, but sometimes I pine for the art style of its equally wonderful predecessor, Civilization 5.