What did Moses do so wrong?--Parashat Hukkat

(1) The Israelites arrived in a body at the wilderness of Zin on the first new moon,*first new moon Of the fortieth year; cf. Num. 33.36–38. and the people stayed at Kadesh. Miriam died there and was buried there. (2) The community was without water, and they joined against Moses and Aaron. (3) The people quarreled with Moses, saying, “If only we had perished when our brothers perished at the instance of ה׳ ! (4) Why have you brought יה’s congregation into this wilderness for us and our beasts to die there? (5) Why did you make us leave Egypt to bring us to this wretched place, a place with no grain or figs or vines or pomegranates? There is not even water to drink!” (6) Moses and Aaron came away from the congregation to the entrance of the Tent of Meeting, and fell on their faces. The Presence of ה׳ appeared to them, (7) and ה׳ spoke to Moses, saying, (8) “You and your brother Aaron take the rod and assemble the community, and before their very eyes order the rock to yield its water. Thus you shall produce water for them from the rock and provide drink for the congregation and their beasts.” (9) Moses took the rod from before ה׳, as he had been commanded. (10) Moses and Aaron assembled the congregation in front of the rock; and he said to them, “Listen, you rebels, shall we get water for you out of this rock?” (11) And Moses raised his hand and struck the rock twice with his rod. Out came copious water, and the community and their beasts drank. (12) But ה׳ said to Moses and Aaron, “Because you did not trust Me enough to affirm My sanctity in the sight of the Israelite people, therefore you shall not lead this congregation into the land that I have given them.” (13) Those are the Waters of Meribah, meaning that the Israelites quarrelled with ה׳ —whose sanctity was affirmed through them.

(1040-1105, France) להקדישני TO SANCTIFY ME — For had you spoken to the rock and it had brought forth water I would have been sanctified before the whole congregation, for they would have said: What is the case with this rock which cannot speak and cannot hear and needs no maintenance? It fulfils the bidding of the Omnipresent God! How much more should we do so?

(1194-1270, Spain) The sin of Moses and Aaron in the [matter of the] waters of Meribah is not clearly expressed in Scripture...
The most likely explanation amongst all those that have been said about this matter, and the one best suited to answer a questioner, is that of Rabbeinu Chananel, who wrote [in his commentary] that the sin consisted of their saying, are ‘we’ to bring you forth water out of this rock? They should [not have said “are we”, but] “shall the Eternal bring you forth water?” just as they had said when ‘the Eternal shall give’ you in the evening flesh to eat etc., and similarly in [the case of all the] miracles they [Moses and Aaron] informed them that the Eternal would do wonders for them. And [since they did not say so here], perhaps the people thought that Moses and Aaron brought forth the water for them out of the rock through their own wisdom [and that it was not a Divine miracle]. This is [what G-d referred to in saying], ye sanctified Me not.