Within the context of Zechariah's prophecies concerning the Messiah (Zechariah 9-14), what is the theological significance of the prophecy regarding the piercing of the one they have pierced (Zechariah 12:10), and how does it relate to the concept of national repentance and mourning in the end times?