It helps you to automate certain repetitive tasks. See Apple's page on it...there are some good tutorials and examples on the right hand side of the page.
You could start by checking the intro on the Apple site, then visit Automator World and take a look at some of the workflows that others have put together. This should give you some idea of what it's all about.