But a lot of things that used to require custom software ... don't, anymore. I think what happens is that the kinds of jobs that are stitched together with Iftt/Zapier/Google sheets/whatever stop being classified as "software," so we've got an ever-moving-target.
There'll always be a frontier that requires deeper technical expertise. But that frontier will keep moving.
I view my career through this lens now: I aim to find things to work on that I believe are very likely to remain in that frontier that remains classified as "software".
I find this useful when thinking about companies and projects. If they seem to be building a CRUD app with clients for different platforms, at a small to medium scale, that might not be far enough into the frontier for me.
This is purely a matter of taste or personality. Another very useful (and probably more lucrative) thing to do is to find ways to leverage the ever-increasing ability to build that kind of simple but useful application for some domain without writing much or any of your own "software". But for me, that just doesn't match my interests as well.
There'll always be a frontier that requires deeper technical expertise. But that frontier will keep moving.