Sex while Pregnant

So I am currently 27 weeks pregnant and tonight I tried to have sex with my so. I found it so difficult to get the energy to do anything and just laid there like a fat cow until I told him I couldn't do it anymore and that it was too uncomfortable. He said it was ok and he enjoys just laying with me. I feel bad because I don't want him o lose interest in having sex with ONLY me, but my body physically is just not capable 😔