You don't seem well versed in the Abrahamic Covenant.
And I will make of you a great nation, and I will bless you and make your name great, so that you will be a blessing. I will bless those who bless you, and him who dishonors you I will curse, and in you all the families of the earth shall be blessed.”
~ Genesis 12:2-3
Know then that it is those of faith who are the sons of Abraham. And the Scripture, foreseeing that God would justify the Gentiles by faith, preached the gospel beforehand to Abraham, saying, “In you shall all the nations be blessed.” So then, those who are of faith are blessed along with Abraham, the man of faith.
~ Galatians 3:7-9
Are you trying to say that the promise made to Abraham in the Abrahamic covenant of his seed being in the land was satisfied when Moses was transfigured?
No, and how did you even come to this conclusion? You could benefit from reading the Abrahamic Covenant in all the places where it is found in scripture. Also, it will benefit you to know that the promise of the Abrahamic Covenant is not meant for Abraham's fleshly descendants, but for the elect of God, those who are Abraham's spiritual descendants by faith.
But it is not as though the word of God has failed. For not all who are descended from Israel belong to Israel, and not all are children of Abraham because they are his offspring, but “Through Isaac shall your offspring be named.” This means that it is not the children of the flesh who are the children of God, but the children of the promise are counted as offspring.
~ Romans 9:6-8
Could we conclude that since Moses was not allowed to enter the land but Joshua and Caleb were, that those two were not under the Sinai Covenant same as Moses?
No we could not. Joshua and all the physical descendants of Jacob (Israel) were under the Sinai/Mosaic Covenant whereby God pronounced blessing upon the nation for obeying all 461 laws and curses upon the nation for disobeying the laws. We read at the end of Joshua where he calls the people to chose. Will they obey the Sinai Covenant or not. Will they serve God or not. The people declare they will, but Joshua tells them they will fail. Why? Because the law doesn't save. The law condemns those who break it.
Moses was disciplined by God for disobeying. His punishment was he could not set foot in the promised land. God, by grace through faith, redeemed Moses through the promise of the Redeemer. Joshua and Caleb were justified the same way. By grace through faith.
thomas15, I encourage you to study the covenants God has made with man. God, through these covenants, established promises. Some are eternal and some are temporary. The Abrahamic Covenant, Davidic Covenant and New Covenant...eternal. The Sinai/Mosaic Covenant... temporary. Jesus fulfilled the Sinai Covenant with his fulfillment of the Law on the cross.