In Civ V (which I have spent an embarrassing amount of hours), by end game I am Ramesses II leading Egypt. I still have functioning burial tombs in my cities granting me additional happiness. I'm still a civ focus around monumental construction with 20% off wonder production. My symbol is still the eye of ra, my colours are still yellow and purple, my city names are still ancient Egyptian, by spy names are still ancient Egyptian, my music theme is still Egyptian.
There's not a lot of mental gymnastics required to get the flavour that you are playing Egypt still, and I think the city names, consistent map colour and music do the bulk of the heavy lifting.
I would prefer that they leant more into that of course, and I agree there's further they could lean into it. But it has been there, and it's why I played.
If I want realism I pick up a paradox game which does it 1000x better. If I want something that doesn't take itself too seriously and allows me to alt history, I pick up Civ. Only not anymore.