I think there will always be a boundary with these tools where if you are building something complex you will reach a point in the project where you need something more advanced than the tool you're using can provide. For me at least, that was the spark to learn to code in the first place. You could call it the law of conservation of code, but I think there is a limitation on how complicated the output a no-code tool can create before it eventually becomes a code tool.

That said, for the chiropractor who needs a website to list his phone number, address, and services, I think a future where he doesn't need to hire a web designer and potentially get scammed (I've seen this a number of times) is a bright one, and I do think we're headed towards a future where the tools are good enough to make very basic front end dev work for situations like this obsolete.