The demo is just a campaign demo. The campaign is quite decent, rent it for a day and you can play the 5 hour long campaign.
Whether or not you like the multiplayer depends on whether you like COD gameplay. Battlefield is easily the best shooter on the market, but MW2 is the best COD game. Try it out though, a lot of people have this game, you must have a mate that'll let you borrow it.