I agree with you 100%. The tools may take away the drudgery of the routine tasks but if you want something really great — you have to code it! There will always be new problems to solve, new domains to conquer and old problems to be revisited for more efficient solutions.
The unbridled optimism of “no coders required” is somewhat like the unbridled optimism of replacing oil and coal with renewable energy sources. History does not support this optimism.