With automated hyperparameter tuning available, do we still need to learn hyperparameter tuning
So do we still need to learn how to do hyperparameter tuning

If you're saying this based on the context of acquiring a new skill, then go for it. It's always a good thing to get an idea an idea of how hyper-parameter testing is done for real. In addition to sagemaker you can use tools like weights and biases