code has never been expensive.
ridiculous asks are expensive. Not understanding limitations of computer systems are expensive.
The main problem is, and always will be communication. engineers are in general are quick to say "that won't work as you described" because they can see the steps that it takes to get there. Sales guys (CEOs) live a completely different world and they "hear" "I won't do that" from technical types. It's the ultimate impedance mismatch and the subject of countless seminars.
AI writing code at least reduces the cost of the inevitable failures, but doesn't solve the root problem.
Successful business will continue be those who's CTO/CEO relationship is a true partnership.