Yes and no. I remember watching an episode of Australian Story about a guy called Adam Sutton. In his adolescence, when his male colleagues were starting to think of girls sexually, he wasn't, and he was thinking, "It'll kick in, it'll kick in, it'll kick in." His mother, who was deeply religious, asked him if he was gay, and he said no. Later on, he realised that he was.
A major misconception with society is that they'll say that a person has "turned gay." What typically happens, especially amongst people who came out as gay later in life is this. Back in the era when homosexuality was considered a mental illness, the more benign advice from some psychiatrists was, for gay men, "Find a good woman, have a good sex life and this will disappear." I remember, in the late 1990s, seeing funeral notices (no, I didn't read them religiously), that would read as say, "Brown, John, late of 6 Anywhere Street, Suburbia. Aged 65. Dearly loved Father of Jennifer, Michael and Sophie, Father-in-law of Thomas, Louise and Joseph, and adored Poppy to Michelle, Jessica and Jarred. Dearly loved partner of Robert Cheng and loved and remembered friend of Margaret. So, John married Margaret and they had children, and John suppressed his homosexuality.
I know a man who has two sons and one daughter and one of his sons and his daughter are both gay.
Unless a parent suppressed their homosexuality, and they had a child who was gay, and their coming out gave them the courage to do so, it's not common for this to occur. I do, however, remember seeing a story about mother and son who transitioned to become father and daughter.
Also, it is not uncommon, especially for late-diagnosed autistic adults, to have been diagnosed after they've had a child diagnosed. And it then becomes that Uncle or Aunty or Grandma or Grandpa were also autistic. Sometimes, for adults without children, it can be from reading an article, or from having a mental health breakdown, that they learn that they're autistic.
Human sexuality is a lot more complicated than neurology, too, don't forget. A person can be heterosexual, homosexual, bisexual, demisexual, pansexual and asexual.
And sometimes, say you went to school with someone who became a teacher, or had an autistic child, and you saw them after 20-30 years and you came out as autistic, rather than saying, "But you don't look autistic," they'll instead reply, "Yes, I remember you from school, and you're just like my son/daughter/non-binary, or just like a child I taught is."