There are lots of tools out there that already have automation elements built in (e.g. social media scheduling, programmatic ads). This will only increase as AI gets integrated into the plethora of adtech and martech products.
What will likely happen is that individual marketers will be able to do more with less, so marketing teams may well slim down to individuals who simply coordinate the tech involved.
There are still parts through that need a human touch - such as creative work and translating data into insights/analysis for various stakeholders.