[QUIX CONTINUED: I realize taxes, that your "Bible" must read something as the above. But I suggest you toss it out and get a more authentic one.]
Sometimes people read into Scripture things that they want it to say. There really is no reason to discuss this issue with you since you utilize as your basis the Old Testament which has been fulfilled by the birth, death and resurrection of Jesus Christ. The covenant established by God in the Old Testament is same as the one today. God declared that He would be the God of those who believed in Him just as He told Abraham. That is still in effect today. The Jews who do not believe in Christ are not in this covenant anymore than the unbeliever is. God's covenant is between Him and His people, and His people are Christians.
You seem to preclude God sovereignly bringing members of all the 12 tribes of Israel into a Saving knowledge of Christ--as Scripture outlines . . .
THEY WILL LOOK ON HIM WHOM THEY PIERCED . . .
Exactly!
The jews broke the so-called covenant when they crucified and then later spurned Jesus Christ and His apostles. Jesus Christ made salvation available for everyone, including the jews, but there was no longer any special relationship for the people who rejected God and his Son. A new covenant was established between God and all who accepted the salvation of Christ. The Catholic catechism and most Protestant churchs persist in this view until now. The passages below are pertinent to this discussion.
...and in the very place where it was said to them, "You are not my people, they will call them sons of the living God...For I could wish that I myself were accused and cut off for the sake of my brethren, my kinsmen by race...
But it is not as though the word of God had failed. For not all who are descended from Israel belong to Israel...
This means that it is not the children of the flesh who are the children of God, but the children of the promise are reckoned as descendands...
And indeed he says in Hosea,
Those who were not my people I will call my people,
What then? Israel failed to obtain what it sought. The elect obtained it, but the rest were hardened. (Romans 9:1-3, 6-8, 24-26; Romans 11:7-8)