Unless you're non-heterosexual yourself, I don't think you can imagine how much it would have meant to non-heterosexuals to have Bev make the more unexpected choice, and realism has nothing to do with it (because realistically there's no reason Bev couldn't have been bisexual or otherwise open to trying to make things work with Odan).
When you're a kid growing up in a heteronormative environment where non-straights seem to be at best politely tolerated and at wost killed for something they have no control over, any positive media indication that there are other people like you and that you're not alone is immensely valuable.
Instead the episode (I'm sure not intentionally) gave off an air of "Sorry kid...oh, did you think we'd take an actual risk with one of our characters? Not on this year's Trek!"
TPTB had the chance to make a statement in the spirit of TOS, and they blew it. And over time, they blew it repeatedly.
All fair points, and I didn't intend to appear insensitive. And I apologize for that. You're right -- it would have meant a lot to quite a few viewers, and I guess sometimes I forget that we're talking about 1991 and not today when the LBGT community has achieved far greater acceptance.