The tragic events at the Waters of Contention illustrate how the complaints of a nation not only provoked divine anger but also sealed the personal fate of their leader. At this location, known as Meribah Kadesh [אבן עזרא, מאירי], the Israelites rebelled and deeply angered God [מצודת ציון, רד״ק, מצודת דוד, ביאור שטיינזלץ]. Consequently, a severe and irreversible punishment fell upon Moses. God decreed that he would die in the desert, forever losing the opportunity to lead the Israelites into the Land of Israel [רד״ק, מצודת דוד, מאירי, אבן עזרא, ביאור שטיינזלץ].
This tragedy was brought about directly because of the people. Their constant resistance wore down the spirit of Moses and pushed him into a state of frustration. Driven by this anger, Moses spoke harsh and improper words. This emotional state prevented him from simply speaking to the rock as God had commanded, which ultimately led to his downfall and subsequent punishment [מלבי״ם].
However, another perspective views this punishment through the lens of God's profound love for the Israelites, even during moments when they provoke Him. Rather than just a consequence of anger, the decree that kept Moses in the desert served a greater, future purpose. Moses remained behind so that, in the time to come, his merit would allow the entire generation that died in the wilderness to enter the land alongside him. In this light, the tragedy that struck Moses was actually a sacrifice made for the eternal benefit of his people [אלשיך].