I know what you mean, and ill be the first to say i was disappointed, as i thought for 2 years id see a new great scifi story.
But, now that we know we better get used to it (i have, so im sure everyone else can

), and what can we do? we can of course come with some suggestions and hope that Sins sells well enough for them to make an expansion where they focus on a campaign.
Also we will get to know the story no matter what, since Blair said in another thread:
the Sins story will be released in some form or another. You have my word. Even in the worst case where the master version of Sins gets deleted by mistake before going gold, I have to go back to working at McDonald's and I'm revealing the story in some obscure blog in the seediest recesses of the internet from my rat infested apartment on a 14.4k internet connection.
So if Sins sells bad i guess we will see Mr Blair at McDonald's
So what did we get instead of a campaign you might ask, well we got a hell of a great game thats for sure. We also had the chance to have an influence on how the game will be, which ive never seen or heard about before.
Theres also still the Advent that haven't been released yet, as well as lots of other stuff.

So it might seem bad right now, but as one might say "theres always light at the end of the tunnel"