Yes, there's no campaign, but the Single Player skirmishes aren't exactly "short missions" either. You can have quite epic games in gigantic star system with many opponents, if you like that.
My approach to Sins of a Solar Empire is similar to my approach to Civilization: I play long games across a few days, and it's quite satisfying.
A campaign would definitely be a nice addition, since the game has such interesting lore. The opening cinematic is so potent that it makes me believe that Ironclad could probably deliver a campaign with fantastic narrative. Would really be awesome for Sins2.