God loves my obedience?

Once again in my reading this morning, I come face-to-face, with my lack of trusting God...of grumbling to Him, as the children of Israel did so many times...but this morning...there's an added twist, one in which when I first read it, really threw me for a loop...Numbers 20:7-8 and the LORD said to Moses, "You and Aaron must take the staff and assemble the entire community. As the people watch, command the rock over there to pour out its water. You will get enough water from the rock to satisfy all the people and their livestock." Specifically, God told Moses to take the rod, but not to use it. Water would be provided if Moses would speak to the rock before their eyes. Back at Mount Sinai, God told Moses to strike the rock and water came forth (Exodus 17:6). But now he was merely to speak to the rock, yet with the rod in his hand. This rod was a symbol of his authority from God. Let's read on...Numbers 20:9-10 So Moses did as he was told. He took the staff from the place where it was kept before the LORD. Then he and Aaron summoned the people to come and gather at the rock. "Listen, you rebels!" he shouted. "Must we bring you water from this rock?" Moses began by doing exactly what the Lord had told him to do: Take the rod, and gather the people of Israel. God did not command him to speak to the nation, and to speak so severely to the nation, yet Moses did. Moses, after doing what God had told him to do, then did something God had not told him to do: He lectured the nation. Worse, he lectured the nation with an attitude of heart he had not shown before - one of anger and contempt for the people of God, with a bitter heart. Worse yet, Moses not only took the rebellion of the people against the Lord too personally, he also over-magnified his own partnership with God: Must we bring water for you out of this rock? Moses spoke as if he and God would do the job, as if they divided the work fifty-fifty; as if God couldn’t bring water unless he was around to speak to the rock. His lapse into contempt for the people led him into a lapse of subtle pride. Moses disobeyed God directly, striking the rock instead of speaking to it. Not only did he strike it, but he struck it twice. When he struck the rock at the beginning of the Exodus journey, he only had to strike it once, but now, out of anger and frustration, he did it twice. Yet, despite Moses’ lapse into sinful attitude and action, God still provided abundantly for the people... "and water gushed out. So all the people and their livestock drank their fill." vs.11 
Vs. 12 But the LORD said to Moses and Aaron, "Because you did not trust me enough to demonstrate my holiness to the people of Israel, you will not lead them into the land I am giving them!" Aw come on now...not Moses! I mean Moses?..."mighty man of God? after all, Moses was Moses! But Moses, great as leader as he was, was still a man subject to God and God’s law? This may seem an excessively harsh punishment for Moses. It seems that with only one slip-up, he now had to die short of the Promised Land...I've struggled with this...
"Obedience, Holiness?" Numbers 20:13 "the people of Israel argued with the Lord, and He demonstrated His Holiness among them." At the waters of Meribah, Moses made God look no different than an angry man or one of the pagan gods...I've often struggled with God’s correction of Moses; he would not lead Israel into the Promised Land. God will get His glory, but will it come through my obedience? This is really serious stuff...God loves my obedience...God should get all the glory, and if I'm obedient To Him, He gets Glory? At the end of it all, God was seen as holy among the children of Israel. Moses did not hallow God in this incident, but God hallowed Himself through the correction of Moses. God will get His glory, God will be hallowed - but will it come through our obedience or our correction?