Do you work for Jiffy Lube?
Yes, it can hurt. I don't know what water pump lubricant is made of, but it could be made of something that damages the pump / cooling system, gunks it up, reduces the effectiveness of the antifreeze, etc.
And it can hurt your wallet. They're not giving this snake oil away for free.