I agree that withdrawing an offer is rare but you have to be OK with some non-zero chance of withdrawal if you’re going to negotiate with only a single offer in hand.
You’re making the negotiating mistake of projecting onto counterparties. “I wouldn’t pull an offer except to an asshole” becomes, “My counterparty won’t withdraw the offer unless I’m an asshole.”
If you absolutely 100% need a job and can leave nothing to chance then you should probably not negotiate with only a single offer in hand.