Let's be honest, consequent turns mechanics of Civilization game is not well-suited for MP. So yeah, it should be SP-first. Although it would be good to see diplomacy and other things working well in MP.
I like to play long mp games. So CIV is a good game for mp. Of course for SP too.
And with a system made to make the mp better, I'm sure civ could be a more mp game.