Like a wasp or bumblebee whose stinger has been removed. His attacks have lost their venom; they are no longer as painful/harmful. Edit: Or, if we're talking about attacks that have already happened, it could mean the sting (pain) has been drawn out of the wound, as with a healing poultice.
New words, one handy idiom, and a 2-minute quiz — delivered to your inbox to keep your streak alive.