This rather underplays the experience of riding a Waymo. Where it works, it works: you get in and it takes you to the place, no human intervention required at any point.
By analogy, the first hands-off coding agents may be like that: they may not work for everything, but where they do, they could work without human intervention.