Yeah, that whole demo was awesome. The sand worm was just the icing on the cake, the cool parts were flying past the space station on your way down, going through the atmosphere, flying around, landing, taking a "golf cart" out, and then while on foot, taking the sniper rifle out and looking at the space station up in the sky through the sights. (btw, rifle scopes are currently broken in 2.5).
And don't get me started on the sandstorm!
LOL, the whole thing was good, but frustrating for people looking for a release date, for anything. We were hoping to get a release date for 2.6...and maybe 3.0, but we didn't get either. They did give a highly detailed roadmap for those, and 3.1, 3.2, 3.3, and even 4.0.
My take is that we are likely looking at Star Citizen release in mid-late 2018. Squadron 42 should be out early/mid 2017.
In the meantime, the game keeps getting better and better. I'm having a blast playing the 2.5 alpha. And I think 2.6 should be out before November 1. That will be interesting, as that will have Star Marine, the FPS. That will bring a lot more people into the game, so if it isn't (damn near) perfect (and everybody is going to have a different definition of "perfect") people will be whining all over the internet.
Edit -- oops, other fave part of the demo was the guy at the top of the mountain who shouted something like "Hi CitizenCon" when you flew by...