This. Check out my username, this is what I do, and I've been doing it for far longer than a decade.

The mid-range jobs have always been vanishing. Many times, I'm the guy automating them out of existence. It's always replaced by something else.

It depends on the circumstances, of course, but there is often more work after the automation than before. It's just different work. It requires reskilling.

The article mentions some new product AWS is coming out with. No matter how "simple" it makes things, someone is going to end up being an expert at using it, and will probably be paid well to do so.

Really, the toughest and most crucial part of this career has been keeping up. The work stays steady, though.