While I don't think TNG's pilot is great, it certainly isn't the worst one. I'd probably rank the pilots like this...
1. "CARETAKER" - This had an advantage the other pilots didn't have: the Maquis were created and were given a decent background in the previous tv season, DS9 season 2/TNG season 7, which allowed this pilot to skip a lot of introduction and exposition that would have otherwise bogged down the pilot. This allowed the episode to focus completely on the VOYAGER story.
2. "BROKEN BOW" - Take out the Temporal Cold War, and I probably would have put it above VGR's. That storyline really hurt the pilot and the series.
3. "EMISSARY" - DS9 nailed the feel of the world and the characters from the jump. It's probably the most personal story for the lead of the series out of all the shows until PICARD came along. Though I rank it third, this one could easily be on equal footing as number 1 and 2.
4. "Strange New Worlds" - Just a very well done episode and story. Having Mount on DISCO season 2 really helped.
5. "THE CAGE"/"WHERE NO MAN HAS GONE BEFORE"/"THE MAN TRAP" - The reason I put them all together is because depending on whether you go by the first pilot, second pilot, or first aired episode, each served as a pilot for TOS. And I would honestly rate them all pretty much equally... solid episodes that tells you what the series is going to be.
6. "Encounter at Farpoint" - I will admit to a bit of a bias because it was what made me a fan of ST and science fiction in general. Otherwise, I would have put it between TAS and PRODIGY.
7. "Second Contact" - A great deal of fun, and it set the tone for the show well.
8. "LOST AND FOUND" - Actually a solid pilot. You really are endeared to the characters pretty quickly.
9. "BEYOND THE FARTHEST STAR" - Very unique ship and a good pilot for TAS.
10. "Remembrance"/"Maps and Legends"/"The End is the Beginning" - This really could have been condensed into 2 episodes, so it feels like it dragged on for far too long. That hurt these episodes overall.
11. "The Vulcan Hello"/"Battle at the Binary Stars" - I just didn't feel that invested in the characters, with the exception of Captain Georgiou. The story just didn't sit well with me, either, because it relied on Burnham performing a mutiny and trying to make it look like that was the right answer. What's worse is that the title ship of the series doesn't even appear! Nor do most of the leads. This makes the pilot feel fragmented, at best. As a pilot episode, whose job is to introduce you to the setting and its lead characters, DISCO's pilot failed spectacularly. This is why it is easily dead last.