You can play MP with CS, but you shouldn't: it's a random game-swinging effect designed for SP. But without CS, there's not much that sets civ5 apart from, well, other boring games.
"Can't" as in "you could, but you'll have just as much fun anally fisting yourself"