Yes, in many cases the role has changed AND evolved - not just because of Agile and DevOps.
I am in the middle of transitioning from having a team of testers report to me to now having the title āpractice leadā. No direct reports, but still many opportunities to contribute to the success of the organization and its mission. This was not necessarily an Agile or DevOps related change. It was more an evolution of team reporting structure to align with other business units in our enterprise.
All of the skills you list are still important to me for being successful in this new role. I already have a strong working relationship with each tester; I hired them, trained them and grew them into their roles with the help of the team. But now I can spend more time coaching and developing specific skills and targeted outcomes with the testers. These are aligned with the product team leads, who I also have a prior strong working relationship established.
There are still needs for test managers in various organizations. I donāt see the role going away anytime soon. But, people in testing leadership roles do need to be aware of the trends, understand how they could be impacted, and be ready to react and evolve if needed. Thankfully, I was well read on the S. Janaway and K. Clokie articles/posts on the test coach role. When the proposed org changes were presented to me, I could write my own job description within 24 hours and begin a plan for the transition.
hth