Thoughts:
Well, here we are, all the way back to 1987 when
TNG made its debut, with the first of several stories involving an ideal word with a terrible secret. The idea and story are actually pretty decent, but the show definitely had a long way to go before they'd get into their “groove”. We are introduced to the mysterious entity who calls himself “Q”, and who will become an important (though infrequent) character for the series. It's fascinating to know that the Q story in this episode was only added after they were granted a full 1.5-hour, feature-length pilot. Originally, the story was only about Farpoint station. Can you imagine how... well, less iconic this series premiere would have been without Q?
As for the crew, Yar is notably more... aggressive and careless than I remember, and in such a way that seems like she's not actually very suited for the professionalism required by her job. This is the only time we'll see Troi in a real Starfleet uniform until halfway through Season 6, because someone working on the show quickly decided that we needed more cleavage and less professionalism on the bridge. However, this early episode does make Troi seem like she's actually more involved in bridge operations. This will quickly die off. We'll also see Miles O'Brien for the first time here, even though he doesn't even have a name yet!
The episode finds excuses to show what the new ship can do: it goes fast, and it breaks in two. Picard orders Riker to perform a “manual” docking of the ship's stardrive section with the saucer section. Typical middle management: stand next to a chair doing nothing, shout out a few orders for other people to do the actual work, and then take all the credit for that “manual” docking. Anyway, the concept for the Enterprise‑D sure is a strange one. It's basically a giant space resort, housing officers and families alike, with stores and salons and schools and restaurants and bars... even the bridge is designed to feel like a comfy living room. This concept comes from an idealized view of the future of space travel, but it is difficult to reconcile the idea with the fact that the flagship of the Federation is often sent into dangerous situations. This is partly why the ship separation feature was introduced: in dangerous situations, the saucer section can carry the civilians to safety while the stardrive section handles the trouble. The problem is, breaking the ship in two every time there's a crisis is impractical from a storytelling perspective, so including this episode, we only see the ship performing this function a grand total of FOUR times (only three times in this series, and once in a movie).
The episode also gives us a glimpse at the new holodeck technology, and a visit by Leonard McCoy at an in-universe age of 137. DeForest Kelley was 67 at the time so, yes, they gave him a heavy coat of makeup to make him appear much more elderly. Finally, we also meet Wesley Crusher, who makes an incursion onto the bridge in this episode, and then takes over the entire ship in the next episode. I think these first two episodes are what expedited Wesley's garnering of annoyance and dislike by audiences.
Compared to the rest of the season, this pilot is actually pretty good. I'm giving it an extra half-star for its efforts to set the series off on a good start. Unfortunately, after this episode, we immediately fall into less-inspired stories until sometime in Season 3.