Next week is advertised as the lesbian body switch episode, where a crippled woman on Earth switches bodies with a lesbian on Destiny and sex ensues.
The production values of the show are quite good, while it uses handheld cameras the effect isn't so pronounced as to be distracting. The set design fits the concept of the ship well, as Destiny is older than Atlantis the ship appears less advanced as well.
The show features an ensemble cast with elements of the Stargate formula from the first two series. The resident super-genius scientist is Dr. Rush, a dour, temperamental Scot. Col. Young is the senior military officer on the ship, who if the formula is followed will stay on the ship while the main team has adventures on alien planets. Lt. Scott fits the role for leader of the team going off ship, the twist being he's an alpha male who's been shown having sex with two different women so far in the first few episodes. Eli is the outsider civilian who lends a perspective to the team, he's a fat gamer who dropped out of college.
And there are characters who aren't part of the normal formula. Camille is a bureaucrat/HR lady who is working for the IOA (International Oversight Advisory) which has its own agenda. Chloe is an angsty twenty-three year old daughter of the Senator who died in the series premier, she jumps into bed with Lt. Scott all the while using Eli as her emotional tampon.
So why do I call this show a train wreck? Because the producers decided to create a more 'adult' show than SG1 or Atlantis and for them that means putting complicated sex lives on camera. So on the Syfy forums there's been constant criticism, the women are all called whores, and the imminent demise of the show is predicted. One of the writers has called out fans who are critical of the show on his blog. From comments the producers have made I expect a lot more complicated relationship/sex drama and not a lot of battles with aliens and explosions.
The premise is interesting but the execution is lacking. I suspect that even though there are steamy scenes, the fact that the crew arrived on the ship during an emergency evacuation with limited supplies and is unlikely to have much in the way of birth control with them is unlikely to be addressed. The women really should be having babies in the second season if they're trying to be at all realistic.