I am admittedly not a Talmud head. But I know that the Talmud records positions that were ultimately rejected. You can't simply quote something from the Talmud and say "This is what Judaism teaches." I would suggest you take this up with one of the many Jews in the forum who are highly knowledgable about the Talmud.
I can tell you, based on having been taught, that Zarehariah 12 is not messianic. Some time in the future, during the Gog magog war, a highly beloved Jew will be pierced, aka killed. His mourning by all of israel will be so extreme that the People will return to faithfulness to the Law.
But the most important thing to note about Zechariah 12:10 is that it doesn't mention anyone coming back from the dead. My question to you was what prophecy there is of the messiah coming back from the dead, and you answer by giving me a verse that has NO MENTION OF THIS. I'm wondering if you are understanding basic English.
Alfred Edersheim lists the passages of scripture that have been messianically applied in rabbinic writings (including the Talmud). He does not state that it is the only opinion, as his quotation makes clear. But the fact that
some rabbis believed the passage to be messianic undermines your argument that there are no Jews who believe it has a messianic application.
In my opinion, it's important to see the coherence and consistency that exists in all of scripture. Giving Zechariah a meaning that has no connection to other passages of scripture demonstrates the failure of the exegete to comprehend the interconnectedness of the books of prophecy. This is understandable if you don't believe the Bible to be a revelation of God, but unacceptable if you believe that God has a clear and consistent message.
There would be no need for a Redeemer if man was not in need of redemption. Job said, 'I know that my Redeemer liveth'. Psalm 19 says, 'O Lord, my strength and my Redeemer'. Isaiah says, 'thus saith the Lord, his Redeemer, the Lord of hosts'. Jeremiah says, 'their Redeemer is strong, the Lord of hosts'.
It is God who comes to earth to pay the price for sin. A sinful man (and ALL men have sinned) cannot redeem himself. The eternal payment for sin must be made by the righteousness of God. The ritual sacrifices for sin, made under the law, are a temporary measure on earth, and they do not satisfy the conditions of God's heavenly and eternal kingdom.
The reason that death and resurrection is central to the mission of the Messiah (aka Son of Joseph) is that, through a sinless man's death, an acceptable payment is made for sin. The obstacle that stands in the way of DOING God's will is removed by God himself. Through faith in the Messiah, the righteousness of God on earth, God's Holy Spirit is poured out on believers.
Jews living under the law do not know the Holy Spirit. In Zechariah 12:10 the Holy Spirit is poured out on the inhabitants of Jerusalem. Why? Because in the moment God saves them from the nations that come against Jerusalem, they will know and trust in Jesus Christ as their Saviour. How will they recognise him? Because they will see him; 'and they shall look upon him whom they have pierced'.
A man who is pierced and killed does not come back from the dead without first being resurrected. Jesus was resurrected from the dead, and ascended to heaven, there to await the time of his coming again in glory. This is what Zechariah 12 talks about. And in Zechariah 13:1 it says, 'In that day there shall be a fountain opened to the house of David and to the inhabitants of Jerusalem for sin and uncleanness.'