Depends imo. If it's purely just a few static pages then yeah I can see this happening but as soon as you have anything like a blog you're going to want some sort of content management system surely to manage it?

What I see this more doing is eliminating the need for someone to code the glue between the CMS and the website -- you can just ask the AI to add code to get your blogs from Contentful