The concept of network automation is an interesting one. It means that configuration, monitoring, troubleshooting etc of network devices are mostly done by computer programs with minimum human supervision. In many cases, network engineers used some scripting to automate pieces of the network, but full network automation means that all this is achieved with the help of computer programs controlling, monitoring and learning from the network devices.
In most cases, it will not. For the first few iterations, at least. It takes time and a few iterations to improve automation and eventually provide a better customer experience. It is crucial to keep this in mind.
The true power of automation has not been seen yet. With self driving cars, trucks and even networks, this will free up humans to pursue other various interesting and/or leisurely activities.(*)
(*) provided that perhaps some form of BI is in place (?)
Network automation is one of the most important things to be achieved in the next few years. This will help with improved experiences for customers of network vendors. It will, in the long run, turn out to be beneficial to the end user, who will experience better quality of service at reduced price. This is also an exciting opportunity to contribute towards this goal!