sorry to post a wiki link but really its best for a general description.
http://en.wikipedia.org/wiki/Sound_card
if you enjoy listening to high fidelity music on your computer than you might want to look at getting one. but if your just mostly gaming or listening to mp3s, the onboard is good enough. (though some gamers really benefit)