A bit of context, I've been told by some people in the church that the account of Moses striking the rock to bring forth water was common practice for shepherds back in the day (pools of water that were trapped under a layer of thin sandstone or something like that), and it was likely a trick Moses learned from his days as a Shepherd.
Is that accurate, or is it a "historical lore" that just crops up sometimes when people try to explain things?
Yes, artisan wells are common and can sensibly be linked to stories of drawing water from stone. Furthermore, individuals belonging to a group of nomadic pastoralists would be likely to know locations of nearby water sources.