Funny how it doesn't lead to any problems in the German, French, Spanish, British, Canadian, Australian, New Zealand, etc., and (one of your favourites) Israeli armies. I suppose the rest of us are sexually a bit more stable than Americans. If you wanna know with whom you're sharing the honour of being too fucking weak to cope with gays, look at it and weep. That's right: China, Iran, Saudi Arabia, Egypt, Yemen, and Brazil for some reason.
NB: I don't for a second believe that American soldiers would be less likely to cope, it's just that your countrymen and women have this tendency to portray yourselves as too mentally weak to deal with that kind of liberty. We have the same problem in the UK in some areas, for example when it comes to 24 hour drinking laws: "oh no, we're British, unlike every other European nation we cannot handle the freedom to be able to buy alcohol around the clock".
Seriously, if you have such a low impression of your fellow countrymen and women you should really do some soul searching and check your attitudes.
All that being said, Prop 8 is a Californian proposition and has fuck all to do with your federal army.