We are told in the scriptures that Moses talked to God like a man talks to a friend (EXODUS 33:11). Only Moses has ever seen the back side of the Glory of God.
This is why I struggle with the decision God made when Moses disobeyed. We only have one record of Moses being disobedient(Numbers 20:10-13) and yet when it happen the result was severe. Moses would lead God's people through the dessert for 40 years and then not be allowed in. I feel for the guy.
I wish the Bible said "Moses walked into the promised land, finally, worshiped God and then dropped" but it doesn't.
This is what it says,
Then Moses went up from the plains of Moab to Mount Nebo, to the top of Pisgah, which is opposite Jericho. And the LORD showed him all the land, Gilead as far as Dan, all Naphtali, the land of Ephraim and Manasseh, all the land of Judah as far as the western sea, the Negeb, and the Plain, that is, the Valley of Jericho the city of palm trees, as far as Zoar. 4And the LORD said to him, "This is the land of which I swore to Abraham, to Isaac, and to Jacob, 'I will give it to your offspring.' I have let you see it with your eyes, but you shall not go over there." So Moses the servant of the LORD died there in the land of Moab, according to the word of the LORD,
What a crazy that day must have been. Hey Moses, I'm going to show you the land and then your coming home.
I think two things (on top of a thousand others) were on Moses' mind that morning. I don't think he was sad about not going into the land as he was sad he sinned against God. It is an important distinction. We sometimes mourn the consequence instead of the turning away. I think Moses understood it because he never showed discontentment with God. Secondly, I think he went down happy in God. He saw with his eyes God's faithfulness would be greater than Moses' and would go beyond Moses. He didn't see the land he saw God's sovereignty. God's grace. God's love. God's purpose. God's greaterness (it's a word now).