I'm trying to stay a step ahead and work "above the algorithm" - learning skills that will always be needed and can't be automated (creativity, team management, translating analytics into actionable insight).
It's difficult to tell how quickly the need to adapt is and the best way to adapt to automation.
(If that is not clear enough - a scientific way to extract all your available economic margin by ways of manipulating you. Of course in a race with competitors to the bottom, knifing each other with the same algorithms. I should write a dystopic scifi book.)
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.
I'd recommend looking into ways to create/review/optimise automations. That way you get to blend tech and marketing, and get to lead on integration of new technologies.