He doesn’t see me like “that” anymore

My SO and I are pregnant with our first child. Recently our lives have been flipped upside down and we’re going through a lot but we’re working hard to make sure everything’s stable when our son arrives. Our sex life has been awful lately and me being super horny and pregnant I’m getting pissed. When we do have sex I have to make the first move etc. I asked him last night about everything and if his feelings were the same etc. He literally told me “I just don’t see you like that right now. Don’t take it the wrong way” he said he looks at me like the “ Devine carrier of his son” I’m a bit confused. Not sure exactly how to feel or if it’s normal. He knows it’s okay for us to have sex he just “doesn’t really want to” and “has too much going on” I completely understand his feelings bringing him down and overwhelming him but if he “doesn’t look at me like that” who does he look at like that? Is our sex life done? Will our relationship work after baby? I don’t want him to just see me as the mother of his child. Like wtf