What motor? If the zetec all you can get is the manual trans TPS, the automatic is not available. Autozone part #TPS274 is for MTX not automatic, the two parts are not compatible and will produce your troubles. Of course other things could too. The automatic one you find that looks different is for the SOHC motor. O'reilly claims automatic one but just try ordering it, a non event.
Bad TPS will screw up idle to where vehicle runs perfectly until you get down around idle, then it spits its' guts out. Have to push down pedal to keep it running. BTDT. They may be able to rig engine to idle but they cannot repeat what must happen as soon as you roll throttle on, or the PROPER increase in volts the TPS provides. The fix for ATX zetec is a new throttle body, Ford modded it fairly early and why no one makes parts for old one, they thought they couldn't sell them. You have to buy the throttle body (and a new connector since old one doesn't work, great work Ford!) to get a proper new ATX TPS. Or...........look at the stickies here for what I did to get around a $200 part. Mine did same as yours in OP but fixed it instantly.
Any mechanic worth his salt can easily measure the TPS voltage to check for the problem................like this..............
manual trans TPS to ATX throttle body-it works