It does sound creepy the way it was said, he could have chosen a better way to express whatever he tried to convey.

I thought about similar things myself many times and brought it up in therapy once. That I never wanted kids, just something I have no interest in and I think I would most likely be an awful mother. My own mom actually desperately wanted me, after >15 years of trying to conceive, many abortions, a baby that died soon after birth etc. But we never had much of a connection and close relationship (for many reasons) and I believe it definitely contributed to my not wanting to be a mother myself even if my personality and interests are also in different places generally.

If anything, it would have been a better way to ask that question "do you think your mom did not want or should not have had kids"?