I have come to fully accept this in my line of work. My knowledge of the internals of software is similar to what a machinist knows about using a manual milling machine. It helps understand what a CNC process is doing at a bit deeper level, and some of the issues that can arise, but holding onto the idea that direct software work will continue to be valuable is similar to a machinist clinging to the idea that they need to position a piece of metal on a plate, pull a lever, and take measurements.
It's even knowledge that should be preserved and is needed for some edge customization or prototype or debugging case, but it's not how the vast majority of work will be done.