"I manage a machine learning team and I also think that at least partially automated data curation and modeling will reduce the number of people required in my field."
I mean, if it doesn't, what the hell are you even doing?
The whole point of technology and modern capitalism is to increase automation, increase the amount produced by the same number of workers, and increase the overall amount of wealth in the world and improve overall living conditions for everyone (setting aside very important questions of distribution). I just find it odd people in the computer technology industry find this shocking or especially worrying.
"I look more at Heroku’s model that AWS and GCP as the future."
Google's App Engine was much closer to the Heroku approach, and the AWS approach won. So I will be pretty surprised if the Heroku approach wins out.