The story
Due to the rarity of whet (“to sharpen a knife; (figurative) to stimulate”) and an association of wet (“to make wet”) with salivating.
Etymology from Wiktionary, CC BY-SA 4.0.
wet someone's appetite
Today it means: Eggcorn of whet someone's appetite Full definition →