My husband and I have tried to have relations twice now... first time we got almost done and he went limp

And said he couldn't feel anything so he stopped. The second time we had a bit to drink and then it happened again? He says it's the lube making him feel this way? We use be cold trojan lube... Anyone ever have this problem? I'm so beside myself 😢