Chukat: Was Hitting the Rock So Horrible?

In this week's parsha, we are introduced to the strange episode of Moshe hitting the rock. Because of this small infraction, we are told, Moshe will not be entering the land with the people of Israel. Why? What was the small act of Moshe talking to the rock meant to teach the people of Israel?