Moses and the Promised Land

Det 3:24 'O Lord GOD, you have only begun to show your servant your greatness and your mighty hand. For what god is there in heaven or on earth who can do such works and mighty acts as yours? 25 Please let me go over and see the good land beyond the Jordan, that good hill country and Lebanon.' 26 But the LORD was angry with me because of you and would not listen to me. And the LORD said to me, 'Enough from you; do not speak to me of this matter again. 27 Go up to the top of Pisgah and lift up your eyes westward and northward and southward and eastward, and look at it with your eyes, for you shall not go over this Jordan.

It seems disheartening that God did not allow Moses into the Promised Land doesn't it?
But before we get downcast lets think about Moses in the New Testament (Moses in the New Testament?!?)

Luke 9:28 Now about eight days after these sayings he took with him Peter and John and James and went up on the mountain to pray. 29 And as he was praying, the appearance of his face was altered, and his clothing became dazzling white. 30 And behold, two men were talking with him, Moses and Elijah, 31 who appeared in glory and spoke of his departure, which he was about to accomplish at Jerusalem. 32 Now Peter and those who were with him were heavy with sleep, but when they became fully awake they saw his glory and the two men who stood with him. 33 And as the men were parting from him, Peter said to Jesus, "Master, it is good that we are here. Let us make three tents, one for you and one for Moses and one for Elijah"— not knowing what he said. 34 As he was saying these things, a cloud came and overshadowed them, and they were afraid as they entered the cloud. 35 And a voice came out of the cloud, saying, "This is my Son, my Chosen One; listen to him!" 36And when the voice had spoken, Jesus was found alone. And they kept silent and told no one in those days anything of what they had seen.

We see here that not only did Moses get to enter the Promised Land but he did it in splendid glory and with the best of company!
But now we need to wrestle with the other text like the Apostles not wanting to leave and fulfill their mission. Aren't we the same way in our Christian walk we want to have those mountain top experiences with God and we wish to go from mountain top to mountain top. But the plants grow in the valleys so our life will be full of ups and downs but we know that Christ is with use through it all. Lastly the statement from God himself "this is my son, listen to him!". This is esp a struggle for me cause anyone who knows me knows I am not the best listener. And Jesus gave commandments so it is not only sitting at his feet (aka the Bible) but following those commandments.