It plays movies. Specifically it plays blu-ray movies on top of regular DVD movies. There's also some other stuff you can do with the PS3, but gaming and bluray movies make up probably 90% of everything people are interested in.
My old DVD player doesn't play re-writeables and this is a feature I want. Friends advise me to buy a PS3 slimline as it does 'everything'. We have a PS2 which is used mostly for Scrabble. What exactly does a PS3 do apart from playing games?

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic