Having Kids - did most of you know you definitely wanted kids? Or did you lean into it?

Late 30s here. Wife wants kids (mid 30s), I don't. Yes, we should have been 100% clear about this, but we weren't and here we are.

I am swinging from yes! lets have a kid (even though I personally feel like it's late for me) to lets adopt a slightly older kid to no! I don't want to have kids whatever the outcome. Is this normal? I know a lot of you have doubts but I doubt one goes from a 100% yes to a 100% no over a span of a few days and back. Any opinion is much appreciated.

Edit: I am so glad to read that most of you didn't just pick on the fact that we should have clarity on this before we got married. Sometimes, life doesn't move the way we want it to. You all have given me a lot to think about. Thanks a ton! Appreciate each and everyone of you. Hopefully I will find a path that me and my wife wont regret in our later years.