Yes, the critically-acclaimed, Emmy Award-nominated, Peabody Award-winning television series that lasted six years (between the miniseries and "Daybreak") is going to be remembered as what not to do when making a science fiction television series.
That's completely plausible.
Yes, NUBSG was popular with critics and fanboys, but its ratings were never that good outside of the first two seasons. That is the reason why it was only four seasons. Sci Fi told them they couldn't guarantee giving them a season five which is why creators simply ended it with season four.
It was never as popular as the huge Sci Fi shows like X-Files or LOST. People shouldn't try to make it into some kind of cultural phenomenon.