TNG, DSN and VOY weren't really flops.
TNG wasn't close to being a flop. In first run it was the highest rated show on TV for the male 18-49 demographic, and the highest-rated first-run syndicated drama. That's why the other Trek spin-offs got made. The ratings steadily declined after TNG, but that took many years and another 18 seasons' worth of Trek.