It depends on the choice of setting. Some aim for accuracy and verisimilitude. Others aim for whimsy and anachronisms.
Oh, I'm definitely on the side of versimilitude in RPGs. I would consider myself a member of the waning group in support of simulationism in RPGs. But you can't fault a system for failing in accuracy when it's not even aimed at the target.
D&D isn't trying to model real world polytheism. In the same boat, it's knights and paladins aren't trying to model real world monotheistic religions. In fact, D&D has made intentional changes over time to move itself further away from real religions and cultures many times.
So, to take things back to the thread topic, I think it's really weird to judge 5e 2024 based on how well it models real world polytheism. In the same vein, I'm more than happy to critique the versimilitude of a Fireball spell based on its coherence with the Evocation school of magic, it's compatibility with magic mechanics, and it's overall consistency with the presented game world. But I'd never critique Fireball for how well it models a mortar explosion, because that's not a thing it's supposed to do. If you're asking a Fireball to model a mortar, that's on you, not the system.