Someone is "thirsty" for sex. A woman (or a broad approximation there of) exploits that thirst, hence "trap".
The "woman" is the thirst trap. Woman is in quotes, because it's almost always not a woman, but a bot, or one of many accounts run by scammers.