Beyond Chatbots: The Rise of AI Agents as Autonomous Executors