Unless it is a Jackson Pollock! 
Visual programming, like any other, is great - until it isn't. The difficulty with it (again, like other styles) is that the transition point is highly personal. One person's Pollock is perfectly clear to someone else.
Visual programming is great for experimentation and discovery. It is also highly useful for prototyping, where you get from initial thought process to something useable very quickly.
But it is much less useful - in my view anyway - for complex production "code". Where the level of complexity and the potential exposure of sensitive processes (sensitive to change, not just security/privacy) increases risk.
So, as usual, a balance is the wise choice.
One of the things that makes Node-RED so useful (again, in my view) is that you have the ability to collapse complex visual flows down to function nodes and also the ability to easily offload complex processes to external services (whether API's, DB engines, etc) thanks to its excellent interop nodes (http, tcp, udp, MQTT, etc).
Well, that is a very strong - and almost certainly indefensible - statement of course. Even more so in the open source world where the cost of the leading AI tools already makes them at least highly restricted if not totally unafordable.
And indeed, many organisations are already finding that their wholesale shift from people to AI for programming is turning out to be both more expensive and less viable.
I'm no AI luddite, I'm fairly sure that people will work out ways to make AI affordable - both in monetary cost and environmental - we are nowhere near that point and neither is AI coding anywhere near reliable enough, even with top-tier AI's, to fully replace human coders.
Sorry, but that is a rather obnoxious statement! Maybe beyond your imagination? The thing is, AI's don't have imagination. They synthesise from human inginuity.
The issue is time and space (and yes, money) to allow people to conjure up amazing things. Then passing those ideas to others to manufacture. If we don't have sufficient people with sufficient time, space and money, we won't get the imaginative, innovative ideas you are (rightly) calling for. AI now has a part to play, for sure but it cannot be the brain of the operation.
It isn't that it has to cost, it is that it costs to create it. Someone has to keep the innovators alive and interested and that cannot happen unless those people are at least well fed, housed and trained/educated. There are many approaches to doing that. Unfortunately, the tech powerhouses of the richest country (USA) are driven by unconstrained capitalism which results in the "Tech Bro's" with all the wealth and acting as the new slave owners. Other countries have a bit more balance but have mostly followed or are following similar patterns.
OK, I need to stop since I've gone well off-topic!
Anyway, what I was trying to get across is that Node-RED's visual programming harness coupled with its node.js and ExpressJS powered service, while fantastic for many things, is not the be-all and end-all of things. Find the balance that is right for each situation and don't get so blinkered that you fall into the trap of owning a hammer and believing everything is now a nail.
Coming back to your original question. Personally, I would think hard about what advantages I might get from using Node-RED. Where are the pain-points in your current approach? Would it be sensible to introduce a visual controller into your processes somewhere? Are there areas where you might want end-users or customers to have more freedom and control? Is Python coding a constraint on your business, would node.js/JavaScript be better?