No sex while pregnant

My husband mentioned as soon as I get pregnant we won’t be having sex anymore. I’m kind of sad because I love him and that’s awhile to go without then of course the postpartum waiting 6+weeks and also life changing after the baby. I was wondering did this happen for anyone else and how did you handle it or compromise?

He basically said it would be weird to have sex while I’m pregnant.