🤷you arent obligated to support him.And he doesn't need anyone to accept his choices in life, so you not accepting him shouldnt affect much.As long as you're respectful and don't call him nasty things or be rude then I see no issue.
People put a lot of expectations on family and get disappointed when it doesnt turn out the way they want.
Friends are for support and sometimes your friends are your family and sometimes they're just family.