I don't understand why people act like science fiction is somehow unwanted on television? Battlestar, Doctor Who, and other shows of recent past show that science fiction will work just fine on TV.
Star Trek had a problem on TV simply because it was creatively dead. It wasn't willing to bend itself enough, and it had been run by the same people for decades. It needed a refresher.
As some of the writers and actors on early TNG said, it was some of the shows own self imposed and arbitrary rules that hurt it. The same is true of the twilight years of Trek.