Moses Struck The Rock Twice

"Take the staff, and assemble the congregation, you and Aaron your brother, and tell the rock before their eyes to yield its water. So you shall bring water out of the rock for them and give drink to the congregation and their cattle." And Moses took the staff from before the Lord, as he commanded him.
Then Moses and Aaron gathered the assembly together before the rock, and he said to them, "Hear now, you rebels: shall we bring water for you out of this rock?" And Moses lifted up his hand and struck the rock with his staff twice, and water came out abundantly, and the congregation drank, and their livestock. (Numbers 20:8-11 ESV)

Moses struck the rock twice when God told him to speak to the rock. Because of that, he cannot lead Israel into the promised land.

And the Lord said to Moses and Aaron, "Because you did not believe in me, to uphold me as holy in the eyes of the people of Israel, therefore you shall not bring this assembly into the land that I have given them." (Numbers 20:12 ESV)

But earlier on another occasion, God did asked Moses to strike the rock once.

Behold, I will stand before you there on the rock at Horeb, and you shall strike the rock, and water shall come out of it, and the people will drink." And Moses did so, in the sight of the elders of Israel. (Exodus 17:6 ESV)

The rock is only allowed to be struck once.

For the death he died he died to sin, once for all, but the life he lives he lives to God. (Romans 6:10 ESV)

And just as it is appointed for man to die once, and after that comes judgment, so Christ, having been offered once to bear the sins of many, will appear a second time, not to deal with sin but to save those who are eagerly waiting for him. (Hebrews 9:27-28 ESV)

For Christ also suffered once for sins, the righteous for the unrighteous, to bring you to God. He was put to death in the body but made alive in the Spirit. (1 Peter 3:18 NIV)

Because the rock was Christ and He died once for our sins.

I would not want you to be unaware that all our fathers were under the cloud, and all passed through the sea, and all were baptized into Moses in the cloud and in the sea; all ate the same spiritual food; and all drank the same spiritual drink, for they drank of that spiritual Rock that followed them, and that Rock was Christ. (1 Corinthians 10:1-4 MEV)

Think I got this verse and the idea that rock was Christ from some YouTube sermon by Adrian Rogers but I have forgotten which sermon.