I've not seen any company which encourages automation lead to burnout.

I think the issue here is what you’re defining as automation. I worked at a managed services provider automating any task that could be automated for over a decade, there will always be more work than can be automated. It just changes too fast for that not to be true, especially when dealing with thousands of different line of business applications and edge cases which are constantly updating.