It supposedly does something to your overall state of being. If I remember correctly, some people are all wound tight because of fluid pressure on the brain, and trepaning was supposed to do something to relieve that.
Now, I'm not saying it WORKS or that I wanted to DO it, but it just sounded interesting.