Well, Yahweh isn't a name, it is a title. So it is more like calling King James "King" or "your royal highness" than calling him James
In
Ex. 3:13-14, Moses asks God, “Whom should I say has sent me?” and God responds by saying, “I AM that I AM… You must say this to the Israelites, ‘I AM has sent me to you.’” However, it could be awkward for Moses to go to the Israelites and Pharaoh and say, “I am has sent me.” So, in
Ex. 3:15 God revises this phrase and changes it to the third person by saying, “Tell them that ‘He is’ has sent you.”
The word “He is” comes from the Hebrew root word
haya, which means, “to be.” It is the third person form of this word, “He is,” that becomes the name Yahweh.
-
https://www.knowingthebible.net/the-meaning-of-yahweh