So what's the point with python for network automation?

I'm a CS student whos been interning at a rural ISP for a couple of years now. As of recently, I've been researching the roles of DevOps engineers and network administrators and automation techniques and technologies that are used in the industries. What I find interesting about the two is that they both seem to have an emphasis on using traditional programming languages to automate tasks that they or others might do on a manual basis. I'm just having trouble finding a point with using a programming language over tools such Terraform and Ansible. What kind of tasks can you do in python that you couldn't do in the aforementioned tools. Being someone who is a fairly competent programmer (albeit in an unprofessional capacity) and works in IT, it just seems like a better idea to use tools that are specific to what is trying to be accomplished. Especially if tasks can be expressed in a more declarative manner and the implementation can be left up to the maintainers of the tools. I haven't actually used Terraform or Ansible before but seeing how they're used, suggesting the use of python seems like we're teaching people to reinvent the wheel each time they want to automate a task.