Me and my wife watched it, and uh, yeah, it was a pilot alright. We generally let pilots slide, since they tend to be info-dumpy and hamfisted. This one was certainly that. We reserve judgment until at least 3 or four episodes in, but it's a solid show so far.
I didn't like how much Superman was referenced. It was reaching Arrow levels of having nearly every character in every scene in the episode swooning over Oliver. It got distracting after about the fifth mention of Superman.
The pacing was way too quick. I don't mind a fast paced movie/show, not at all, when handled well. The problem with this pilot is that it had so much ground to cover that the emotional beats weren't given enough time to breath. The conflict between Kara and her sister was brushed past too fast. The inner conflict between Kara and her desire to be her own hero not in Superman's shadow is brushed past. The conflict between Kara and the discount CADMUS was rushed through.
I get they really wanted to get her up and running as Supergirl, but I truly feel like it deserved a 2 hour premiere. They crammed a 2 hour movie's worth of plot and development into a 46 minute episode of a TV show. Some of the writing was also sloppy and hamfisted. And I really don't like her friend zone buddy. Jimmy and Cat are great, and her sister is believable. Henshaw is an asshole, but that makes sense.
Ok, now that that shit is out of the way:
I love Kara. No, she's not my...waifu (ugh), but she is incredibly adorable, likable, and has some great screen presence. Melissa Benoist was a great choice for her. She's earnest and sweet, but looks like she can pull off the aggression and confidence needed to make Supergirl believable. I really like her.
The visual effects are very good, about what I'd expect from a modern superhero TV show from the Flash crew. No complaints there. And honestly, as long as it doesn't look like Lois and Clark (which I own on DVD XD), I'm good.
Overall, it was a solid, yet flawed pilot, but I'm excited to see where it goes now that the introduction is out of the way. That season teaser looked really promising.
Man, I really wish it was a two hour premiere...