Moses did finally yield to God and obey, but he still struggled to lead the Israelites. The children of Israel complained constantly, although God had moved for them in dramatic fashion.
Take a look at Numbers 20:2-11:
Now there was no water for the congregation; so they gathered together against Moses and Aaron. And the people contended with Moses and spoke, saying: “If only we had died when our brethren died before the Lord! Why have you brought up the assembly of the Lord into this wilderness, that we and our animals should die here? And why have you made us come up out of Egypt, to bring us to this evil place? It is not a place of grain or figs or vines or pomegranates; nor is there any water to drink.” So Moses and Aaron went from the presence of the assembly to the door of the tabernacle of meeting, and they fell on their faces. And the glory of the Lord appeared to them.
Then the Lord spoke to Moses, saying, “Take the rod; you and your brother Aaron gather the congregation together. Speak to the rock before their eyes, and it will yield its water; thus you shall bring water for them out of the rock, and give drink to the congregation and their animals.” So Moses took the rod from before the Lord as He commanded him.
And Moses and Aaron gathered the assembly together before the rock; and he said to them, “Hear now, you rebels! Must we bring water for you out of this rock?” Then Moses lifted his hand and struck the rock twice with his rod; and water came out abundantly, and the congregation and their animals drank.
The Manna Chef 