Queer couples and activists say disappointment is an “understatement” for their feelings, worry about impact of ruling on those facing opposition from their families