Woodpeckers are generally beneficial to trees. By drilling into bark to remove insects, they help protect trees from pest damage. The cavities they create also provide nesting sites for other birds, such as bluebirds and chickadees.
While the holes may look damaging, the overall ecological effect is positive.