Am I misreading this it are you claiming the family of trans people becoming more transphobic when they find out not common? Because it's extremely common. There's a reason the joke exists: Don't like in-laws? Date a trans person and you won't have to worry about them!
I agree that it's not the usual response, but given Musk's strong promotion of natalism and the fact that he has used IVF to select XY embryos for _all_ of his offspring...