Did Moses hitting the rock for water lead to any consequences or repercussions in the biblical narrative?

Yes, in the biblical narrative, Moses hitting the rock for water instead of speaking to it as instructed by God led to consequences. As a result of this disobedience, Moses was not allowed to enter the Promised Land.