Check back in six months to a year
... and possibly after the first paid expansion
To be honest, I'm feeling pretty burned. The state of the game *now* would be a good, solid, REAL beta test. It has all the pieces in place. It has lots of little bugs (and some major ones). But it has huge, huge gameplay issues, on every balance front, from AI to city development to spellcasting to tactical combat to army buildup to research to exploration, etcetcetc.
Worse, it has issues with simple blandness and Not Fun, in the tactical combat, the questing, the monster combat, and perhaps worst of all, in the magic system, something that should be one of the most interesting and enjoyable areas of the game to explore.
As a $50 (preorder!) purchase, it's a bit difficult to swallow (particularly since I'm one of the people inflicted with the awful, awful <10fps bug)
I've beaten on the AI repeatedly on every high difficulty level, even trying to avoid the most egregious of the balance issues in the game right now, but it simply doesn't present a challenge to an experienced thinking player, and in some cases, it won't even present a challenge even if you don't threaten it.
As for GC2/Sins - Sins wasn't their game.
I found GC2 to be extremely lackluster and boring on release, and the first expansion didn't do much for me. The second expansion however, was a major revamp of the game, and while I still find GC2 to be a very flavorless, almost empty experience, mechanically it was quite sound, and the AI was decently challenging (and had pretty cool behaviorlets that made it feel somewhat organic, a high compliment for AI in any game).
So, long story short - I don't see any reason Stardock would drop their support of this game. They have the team, they have the money and the time. The fact that it isn't in great shape now sucks (a lot), but they will likely continue to support it. In six months, patches should have cleaned up all major technical issues, nearly all of the minor bugs, and addressed many of the larger balance issues. Whether or not they will have addressed the simple Fun aspect of the game is a question (and answer) much more open to individual interpretation.
In a year, we'll probably see a good paid expansion pack that will (hopefully) enhance and extend the gameplay in various areas. Assuming the community sticks with the game, that's also around the time we can expect to see some larger mod projects that might be interesting.
I find the current launch situation pretty unpleasant all around. It has definitely damaged my opinion of Stardock as a whole, and while I still have reasonable confidence that they will improve the game, I'm shocked they shipped the game in this condition.
tldr: Yes, they'll improve it in time.