If you never seen Seaquest before the pilot is a good litmus test if you will like the series or not - it is at least tied for best in the series. The grand intro theme catches your attention right away, and really screams out its a pretty high budget production. The cast is slowly introduced to you one by one, with just enough lines to get to know them, well paced. Soon we get to the series main star, Captain Bridger, played by the late Roy Schnieder. His intro I found a bit lengthy, but perhaps necessary to explain his reluctance of wanting to return to Seaquest. We actually meet his current successor first, Captain Stark, in a climactic scene early on (not to give too much away). Stark, played by Shelley Hack, is quite menacing and believable in her role, and ends up being a worthy challenge for Bridger's wits.
While some of the storyline has a cliche feel to it, the underwater element adds some new elements. Suffice it to say there was no dolphin in Star Trek or Battlestar that ever played a key part in saving the day. The special effects still hold up good enough that they don't detract. Again, if you are the remotest sci fi fan, you owe it to yourself to check out the pilot of Seaquest DSV.