I am leaning towards the idea that
Rev 12 shows what God made of Israel/Judah
Rev 17 shows what she became
Both of those are on Earth
Rev 21.9 shows “the new Jerusalem....the wife of the
Lamb”.
The new Jerusalem, in contrast to the other two, comes down from Heaven
that in Rev 12, the woman is Israel/Judah in the past, described broadly as in Ezekiel 16.8-14:
8Then I passed by and saw you, and you were indeed old enough for love. So I spread My cloak over you and covered your nakedness. I pledged Myself to you, entered into a covenant with you, and you became Mine, declares the Lord GOD.
9Then I bathed you with water, rinsed off your blood, and anointed you with oil.
10I clothed you in embroidered cloth and gave you sandals of fine leather. I wrapped you in fine linen and covered you with silk.
11I adorned you with jewelry, and I put bracelets on your wrists and a chain around your neck.
12I put a ring in your nose, earrings on your ears, and a beautiful crown upon your head.
13So you were adorned with gold and silver, and your clothing was made of fine linen, silk, and embroidered cloth. You ate fine flour, honey, and oil. You became very beautiful and rose to be queen.
14Your fame spread among the nations on account of your beauty, for it was perfect in the splendor I bestowed on you, declares the Lord GOD.
The mention of the dragon, and the waters, is consistent with an identification of the Woman of 12 as Israel/Judah.
that in Rev 17, the same woman is Israel/Judah in the 1st-century present, broadly as in Ezekiel 16.15-26:
15But because of your fame, you trusted in your beauty and played the harlot. You lavished your favors on everyone who passed by, and your beauty was theirs for the asking.
16You took some of your garments and made colorful high places for yourself, and on them you prostituted yourself. Such things should not have happened; never should they have occurred!
17You also took the fine jewelry of gold and silver I had given you, and you made male idols with which to prostitute yourself.
18You took your embroidered garments to cover them, and you set My oil and incense before them.
19And you set before them as a pleasing aroma the food I had given you—the fine flour, oil, and honey that I had fed you. That is what happened, declares the Lord GOD.
20You even took the sons and daughters you bore to Me and sacrificed them as food to idols. Was your prostitution not enough?
21You slaughtered My children and delivered them up through the fire to idols.
22And in all your abominations and acts of prostitution, you did not remember the days of your youth when you were naked and bare, wallowing in your own blood.
23Woe! Woe to you, declares the Lord GOD. And in addition to all your other wickedness,
24you built yourself a mound and made yourself a lofty shrine in every public square.
25At the head of every street you built your lofty shrines and degraded your beauty. With increasing promiscuity, you spread your legs to all who passed by.
26You prostituted yourself with your lustful neighbors, the Egyptians, and increased your promiscuity to provoke Me to anger.
that in Rev 21.9, the “new Jerusalem”, the “bride of the Lamb”, is the Heavenly city of God & community of the redeemed (including Israel/Judah) in the eschatological future. The earthly Jerusalem of human experience is a corruptible & passing approximation to, and copy of, the Jerusalem that “comes down from Heaven”.