https://www.aei.org/economics/what-atms-bank-tellers-rise-ro...
This doesn't always happen mind you. But it shows that your (and my) economic instincts are piss poor. We can't just assume what the future holds.
-------
Another few examples:
3D animation has killed a lot of tweening artists (the people who smoothed out animations for Disney Films like 101 Dalmations or Sleeping Beauty). But 3d animation created the need of modelers, texture artists, riggers, and more.
Automatic Drum machines didn't kill drummers either, but allowed for more music to be made in general.
The only thing that automation "killed" recently was Lawyers, as online webpages that auto-generated common forms removed a ton of jobs that Lawyers used to do. IIRC, Lawyers are in somewhat of a decline because of this.
So it just goes to show that no one really can predict these things.