When Barry awakes from this, it's nine months later, the woman he grew up with, Iris, is dating the perfect cop, the world has moved on ..... and Barry can move faster than a ray of light.
The interesting part of the show is how they've decided to develop their rogues gallery. The explosion that created him unleashed all sorts of theoretical elements upon the city, warping and shaping various and sundry people in multiple different ways. It's a nice, simple way of pulling this off, and much better than what was initially done on Smallville -- which, if you remember, consisted of radiation from kryptonite creating a host of different mutations on parts of the population -- which was a cheap way of turning Smallville from Kansas into the Hellmouth from Buffy the Vampire Slayer.
The short version is that I like this series. Character traits are quickly and easily set up. Barry is basically a good kid with a backstory that originally had him as the police department's Mulder. We've got the tinkerer, the misanthrope, the mentor (who's looking a little sinister by the end of the episode) and the love interest who friend-zoned Barry in the first three minutes of the episode.
And there are enough little details to satisfy most people. During a monologue, Barry Allen declares himself the Fastest Man Alive, the tag on half his comic books. The news station is channel 52 -- like the New 52 of the DCU. There are minor cops brought in from all over the comic books, One of the reporters is a Linda Park, who married Kid Flash in the comics. Barry's father is played by the actor from the original 1990 Flash tv show. Ferris air, of Green Lantern fame, makes an appearance.
There's also a giant gorilla cage broken in the aftermath of the explosion. It's labelled "Grodd." If you've read the comics, I don't need to explain. If you haven't, there's no way I can explain it without it sounding stupid.
The short version: I liked this show. The cast aren't as deep as I would have liked, but it's only the pilot. As it stands right this minute, I'll happily watch the rest of the show. But since this is from the same team that brought you Arrow, we can only expect that things are going to get much better from here.