AI-generated code still requires software engineers to build, test, debug, deploy, secure, monitor, be on-call, support, handle incidents, and so on. That's very expensive. It is much cheaper to pay a small monthly fee to a SaaS company.
No, they don't.
A domain expert armed with an Excel spreadsheet and the ability to write VBA macros will be enough for most business.