That has to be one of the most emotionally intense moments I've ever experienced in a TV series.
Yeah that beat was the biggest gut punch and tearjerker in an episode full of them, at least for me.
BSG is my easily my favorite sci-fi series and competes with Lost (maybe Rome as well) for all time favorite regardless of genre. My favorite science fiction understands that the character drama is the important bit. In those stories the sci-fi setting exists as scaffolding to push characters in unique ways and explore aspects of the human condition that would be impossible otherwise.