It's definitely 'a' future, in that there's no good reason why it would go away. It'll get better and better, but there'll always be something it can't do well.

For me, the key to a no-code solution is that it provides an escape hatch into code when necessary. If I have that, the no-code stuff is actually really nice.