Demystifying AI Agents: Your Programming Superpower, Not Your Replacement!