Roddenberry's original edict to Rick Berman was "no conflict among the main characters." So, if Riker questioned one of Picard's orders, he was just expected to go along with it (no doubt Picard would have some technobabble-explanation of his reasoning). In later seasons, if Picard was questioned, it usually led to some sort of tension between the characters, which is more realistic IMNSHO than a conflict-free crew.FreddyE1977 said:The first couple of seasons of Star Trek TNG were quite tedious.
It was only when Gene Roddenberry died and the producers gave up on
his vision of a "non-violent action/adventure series" that they were
free to build it into a successful show.
But Roddenberry also believed in an unrealistic, utopian future for mankind. While it helped TOS a bit in the '60s (they were better able to tell "morality plays" then), it bit him in the butt in the first two seasons of TNG. The only saving grace was that the show was syndicated and stations signed a 5-year contract (the show ultimately ran for 7).