'Zechariah 12:10 is applied to the Messiah the Son of Joseph in the Talmud (Sukk.52 a) and so is verse 12, there being, however, a difference of opinion whether the mourning is caused by the death of the Messiah the Son of Joseph, or else on account of the evil concupiscence (Yetser haRa).' [Edersheim]
If one believes that the Tanakh is the Word of God, as I do, then one has to view these scriptures as authored by God and not by man. This means that time does not obscure the repeated truths that appear throughout the various books of scripture. One such truth, to my understanding, is that the Messiah, Son of Joseph (the Suffering Servant), would die for the sins of both Jew and Gentile alike (if they be his friends). It is no surprise that Jesus said, 'Greater love hath no man than this, that a man lay down his life for his friends', for, indeed, this is what Jesus did for his friends. And anyone can be his friend if they accept Jesus' words and actions as truth.
Based on this reasoning, that Christ is the focus of God's redemptive plan, we read that Jesus called out 'My God, my God, why hast thou forsaken me' whilst hanging on the cross [Matthew 27:46]. This is, as you well know, the opening of Psalm 22. Jesus quoted these words to draw peoples' attention to the whole Psalm, which graphically portrays the death of a man after 'piercing' (like a lion tearing at his hands and feet). Yet, rather than being forsaken by God, the man finds salvation in God. To find salvation means that he does not forever descend into the grave, but is brought forth in resurrection, as we read in Psalm 23.