In the show, it’s his desire to be a healer and embrace Federation science that causes tension with his family. Of that, I’d argue his family was visibly more angry about him embracing the Federation.

Given that his parents are a polyamorous throuple it seems likely that if there is any anti-gay bigotry in Klingon culture it wouldn’t come from his parents.