Yes, according to the context of this passage, there are two YHWH's and I think the author(s) of the passage wanted the reader to get this impression. This is a good question that has far reaching implications on the reading of the whole Bible if it is to be taken literally and consistently. There is YHWH in the heavens, who Jesus referred to as God the Father. Other Biblical writers such as John 1:18 states that: "No man hath seen God at any time; the only begotten Son, which is in the bosom of the Father, he hath declared him."
Compare 1 John 4:12 and 1 Timothy 6:16, all these passages are based in part on Exodus 33:20 “And he (YHWH) said, Thou canst not see my face: for there shall no man see me, and live.” Which makes the YHWH who came to Abraham at Mamre with the two angels very interesting. Because Abraham, a man, saw Him and he didn't die, in fact he went on to live for a very long time afterwards. He came in human form, He washed His feet and did eat and drink with Abraham.
What's even more interesting is that Jesus implied that He was this YHWH figure. In John 8:56 Jesus says; "Your father Abraham rejoiced to see My day, and he saw it and was glad.” The Idumeans, "Jews", were incredulous. But Jesus went on to say in verse 58; “Most assuredly, I say to you, before Abraham was, I AM.” At this the "Jews" immediately picked up stones to stone Him. Because they knew exactly what He was saying; not only was He claiming to be YHWH, He was claiming to be this second YHWH figure who came to Abraham at Mamre. Jesus also said that He and the Father are one, distinct but one. This duality of God being both Elohim and YHWH, physical and spiritual, in heaven and on earth is played out all throughout the Bible from the very beginning. For example, Elohim created the heavens and the earth but YHWH formed Adam out of the dust of the ground.
The theme is carried out throughout the Bible by different authors who had the opportunity to change it, but actually they make the matter even more complicated. The following two passages illustrate how YHWH refers to God (Elohim) in the third person. Jeremiah 50:40 continues the theme of Genesis 19:24,25. It states; "As God overthrew Sodom and Gomorrah and the neighbour cities thereof, saith the LORD; so shall no man abide there, neither shall any son of man dwell therein." Amos 4:11 reinforces the significance of Genesis !9:24,25 by stating; "I have overthrown some of you, as God overthrew Sodom and Gomorrah, and ye were as a firebrand plucked out of the burning: yet have ye not returned unto me, saith the LORD."
Starting in Genesis various passages make a distinction between the Angel of YHWH and YHWH. I think this is an attempt by the author(s) to deal with the issue of the two YHWH's. But it is clear from the text that no such distinction exist in the mind of the Angel of YHWH, YHWH Himself and the protagonist. To illustrate I am going to use the story of Gideon from the book of Judges (Elohim) 6:21-24.
21 Then the angel of the LORD put forth the end of the staff that was in his hand, and touched the flesh and the unleavened cakes; and there rose up fire out of the rock, and consumed the flesh and the unleavened cakes. Then the angel of the LORD departed out of his sight.
22 And when Gideon perceived that he was an angel of the LORD, Gideon said, Alas, O LORD God! for because I have seen an angel of the LORD face to face.
23 And the LORD said unto him, Peace be unto thee; fear not: thou shalt not die.
24 Then Gideon built an altar there unto the LORD, and called it YHWH-shalom: unto this day it is yet in Ophrah of the Abiezrites.
In this lengthy passage, Gideon is talking to the physical Angel of YHWH, but YHWH is also present in the Spirit and also talks with him. Even after the Angel departs from Gideon, YHWH continues to speak with him even though He can't be seen.
The two YHWH's are found all throughout Scripture. When YHWH comes down from the heavens He declares the Name of YHWH, in the third person. He can also make it rain upon the earth brimstone and fire from YHWH out of the heavens. The Hebrew word; מֵאֵ֥ת transliterated as me'et literally means from. Which will indicate that one YHWH was on the earth and the other YHWH was in the heavens, for something to come from Him. I would like to stress that YHWH is one, just like the shema claims. God is Spirit, His physical manifestation is also called God (Elohim), Adam and Abraham knew Him as YHWH, Jacob knew Him as the Angel of YHWH, Moses knew Him as YHWH-salvation. Which is why he changed Hoshea (Deliverer) the son of Nun's name to Yahushua meaning YHWH is salvation. Even David in Psalm 110:1 says: "YHWH said to my Lord, sit thou upon My right hand until I make your enemies a footstool." Who is David's Lord? The answer is simple, it's none other than Yahushua HaMashiach which became Yehoshua, which became Yeshua, which became Iesous and ultimately became Jesus.