On A White Horse

"10“I will pour out on the house of David and on the inhabitants of Jerusalem, the Spirit of grace and of supplication, so that they will look on Me whom they have pierced; and they will mourn for Him, as one mourns for an only son, and they will weep bitterly over Him like the bitter weeping over a firstborn." Zechariah 12:10

7Behold, He is coming with the clouds, and every eye will see Him, even those who pierced Him; and all the tribes of the earth will mourn over Him. So it is to be. Amen.
8“I am the Alpha and the Omega,” says the Lord God, “who is and who was and who is to come, the Almighty.” Revelation 1:7

I wondered-why the mourning noted in Zechariah? Why would those who see Jesus returning be mourning?
"they will look on Me whom they have pierced" "they will mourn for Him" the change from 'Me' to 'Him' is also puzzling. Quickly! To the Quickverse! (I have an embarrassment of digital riches on my computer, a full library of Bible study works, commentaries, versions of the Bible, etc.)
The consensus view of Zechariah 12:10 is that Jesus Christ (the Me quoted), on His return, will be recognized by the Jews as the Messiah (the Him noted) they missed 2000 years ago. They will be face to face with the reality that their religion has sent untold millions of their loved ones to hell-and please, if you think I'm gloating, Lu, I'm not. I'd rather see Heaven full and hell empty. But our wishes change nothing.
"and all the tribes of the earth will mourn over Him." Think about that for a moment.
If what the Bible states is true, if Christians are right about Who Jesus Christ is, at His return the entire world is going to be flipped upside down metaphorically.
All other religions, such as Islam and Hindi pantheism-dust and gone.
All cruel governments which hold people in bondage, from China to Cuba to you name it-gone. Tossed over the cliff of insignificance. Christ will rule from His capitol, Jerusalem.
So it is to be. Amen.