Honestly, I'm not sure if I'll be able to look at the game the same way.
Sure, I'm sure there were a lot of problems with the game at that point. There are with all demos, all beta versions.
But if there's one crucial difference I see between the two versions, it's that the game at this stage seems like it knows you're going to win. The creature stage, for example, looks like it's more difficult and gives you more time-you're investing points in your brain, for example, not having your brain size automatically increase. And I like that-that's more realistic, more interesting and seems more fun and rewarding to me.
Same thing with the tribe stage: You're buying fires, huts, weapons and instruments, and they're reacting to them-you're not directing them. And I can see problems with that-I imagine some players would be frustrated when the AI screws up and does something completely wrong. But the idea of influencing, not directing, your tribe is an interesting one that was tossed out when the game was dumbed down.
Civ phase suffered a similar fate: the cities in the video appear more complex and have more buildings than just 'town hall/house/factory/entertainment'. The conquest game seems the same, but the planet looked larger, more complex and more challenging.
Space stage looks about the same-though planets look larger, again. Of course, those had to be scaled down to be easier on everyone's systems.
Anyway, my point is, it looks like the game's been significantly dumbed down-I can't tell if they realized that they had no target genre and decided it would be best if they marketed it to casual crowds, EA wanted it stripped down to sell about a dozen expansions or they simply ran out of time and cut out features that weren't working out quite as well as they should.
Hopefully, they'll make the gameplay better and make the game a little bit more complex with a few expansions-who knows, maybe a year or two from now I'll look back on this post and sound like a ranting fool (I already do, don't I?

Edit: Oh, and that tophat looks sweet.