I think that either our bodies or our minds would go "poof"...
That is why God has always worked through an intermediary, an agent... that can appear to us, without those consequences... we can use the parallel of an avatar for the purpose in defining that agent. There is not one single instance where God appears in his overwhelming Spiritual form. Even the example you quoted in the OP does not have God appearing in his fullness. Moses was just given a taste.
What we have are many instances of God using his intermediary form, an avatar so to speak, that is variously described by a number of terms. "His Word", "His Angel" and a number of others. What is interesting is that these all use the name of God as their own. They are not a messenger, they are taken to be God himself.
I think you both are saying the same thing actually. I wonder if we'd call those intermediaries and agents archetypes, Jorel? Just a thought I had, maybe, huh? Why do we project unconscious things onto a being? What if we didn't project it, would we go poof?