Although I've seen that sort of thing attempted in fictions (not necessarily Stargate ones per se) they always ring false to me for this reason: I have never seen an intense, close, deep friendship out in the real world between an unrelated adult heterosexual male and heterosexual female that did not have some definite sexual tension. It may not lead to RST, it may not cross lines or boundaries, but it is there, and once you have that, there is shippiness sitting there like the proverbial elephant in the living room. I think I'd read it, and evaluate it for what it was, but I don't think I'd buy the premise.

This is also, btw, the reason why even though I am a Sam/Jack shipper, I don't really buy the "Sam and Daniel soo brother and sister" argument either. While I can see Daniel saying "You know I love you like a sister, Sam," the internal view is more likely to be "While I'm quite aware of your considerable charms, I'm also equally aware of your focus on Jack and his whole alpha-male-territoriality schtick."

That said, sexual tension notwithstanding, I think that mature well adjusted human beings can see and identify that sexual tension for what it is, and choose to not to act on it. I do think, for instance, that wives of patrolmen or firemen, or paramedics whose husbands work with women partners in situations of high tension that are conducive to the formation of deep bonds should not feel threatened if they know that their husbands love them and are committed to their relationship. I have absolutely no fear that my husband the physician is going to wander off with one of the paramedics after running a code. He is married, not dead, but is mature and adult and is capable of storing up that sexual frustration and bringing it home to me, and doing anything else would devastate his sense of who he is, just as bedding Sam would devastate Daniel if Sha're were alive and easily available to him.