This is a really interesting question, and I believe the reason Stargate is popular across a wide demographic is because it's based now, not in the future. It's set in 2001, and although there is the obvious sci-fi aspect of aliens, technology etc... the main characters, with the exception of Teal'c, are humans from our time, and we can associate with that.
I've thought about this a lot, coz I used to be a huge Star Trek TNG fan, many years ago, but now when I watch it, I can't believe how morally superior the show tried to be. Stargate isn't like that, generally. It has a moral side to it, sure, but not in a high and mighty way. It shows real people dealing with both real and unreal situations, and I think we can all see parts of ourselves in one or other of the characters, or at least in their reactions to situations.
It shows that people make mistakes, and have to deal with those mistakes as they happen, unlike a lot of other sci-fi shows. I don't mean to sound like I'm knocking other shows, but at the moment, Stargate is the only sci-fi type show that I watch regularly. I still try to keep up with others, but none of them really 'touch' me anymore. Stargate has a real human quality - or maybe that's just my perception of it.
I've thought about this a lot, coz I used to be a huge Star Trek TNG fan, many years ago, but now when I watch it, I can't believe how morally superior the show tried to be. Stargate isn't like that, generally. It has a moral side to it, sure, but not in a high and mighty way. It shows real people dealing with both real and unreal situations, and I think we can all see parts of ourselves in one or other of the characters, or at least in their reactions to situations.
It shows that people make mistakes, and have to deal with those mistakes as they happen, unlike a lot of other sci-fi shows. I don't mean to sound like I'm knocking other shows, but at the moment, Stargate is the only sci-fi type show that I watch regularly. I still try to keep up with others, but none of them really 'touch' me anymore. Stargate has a real human quality - or maybe that's just my perception of it.