This is the rub right here. Huge mental overhead that is often not mentioned.
Not only the potential for great consequence (think errant deployment in AWS S3 that takes out an entire region and costs the company millions), but the requirement to constantly be evolving and learning new things. Not only learning but being proficient at them. All while not forgetting the original stuff you knew.