wrote
OK, now I know that I am not supposed to use it like a drill bit, and I
am supposed to use the tap-wrench. In other words, the hardware store
owner gave me the correct instruction. There must be something missing
in the "execution".

I wouldn't worry about it. Sounds like the one thing the hardware guy
neglected to mention is that they don't always work.