We are so starved of good sci fi, why not junk some of the crap game shows etc, and put the money into wholesome sci fi? Star gate (must) have been very popular, and made oodles of cash.
Game shows and reality shows are dirt cheap to produce. They don't need writers or elaborate sets. No prima-donna stars, just contestants who beg and plead to work for free, and maybe or maybe not a band, which is pretty cheap these days. The prize money is peanuts compared to the cost of producing a real show, which can be more than a million dollars an hour. No rehearsals. It's a network CFO's dream.
Stargate was probably not as expensive as Star Trek or Bab 5 because computer video technology had matured. And except for McGyver, they hired all unknown actors who probably worked for reasonable wages. Browder and Black are known to us from Farscape, but they're hardly stars in the real world. Still, Stargate was on basic cable and couldn't possibly have had more than two million viewers, which is nothing. Advertisers do not pay "oodles of cash" for a show with only two million viewers.
Jon Stewart makes a pretty fair income on basic cable, but it's because he's on every night, about 48 weeks out of the year. He works his tail off. That's 240 episodes compared to 20-25 for most "weekly" shows. The cost to produce one nightly episode of the Daily Show is pretty low. A lot of times they don't even re-do flubbed lines, just like soap operas.
Most people are not like us, sci fi is not all that popular. The Star Trek franchise was a veritable phenomenon, and it struggled along on network TV with a typical audience of three to five million, barely enough to keep itself on the air.