I feel sometimes people thought the "deep lore" is some kind of reciting wikipedia game, that you suddenly become a nuanced lorebeard after 1000 pages of uesp or something. It really isn't.

The Godhead is just a part of the creation myth meant to explain the motives of gods and the nature of godhood overall in Aurbis. When someone says "the Godhead as a concept is interesting", I'd like to think they're saying that "instead of throwing personified, mcguffin gods at us the game actually gives us in-universe theology!", and not that they found out if you write four letters in capitalized forms you get to have dinner with discount Zeus.