Hype vs. Reality: Are Autonomous AI Agents Ready for Real-World Enterprise Demands?