The Uncomfortable Truth About AI Agents: 90% Claim Success, 10% Adopt