Sometimes people have different reactions to medications. Could it be that it wasn't strong enough for you and instead of knocking you it did the opposite?
I have bad insomnia and have tried lots of things for it. I have also been told to take hot baths, try to relax, etc. Are people kidding??? I have found that with me some pain/sleep aid meds either don't work, make me hyper or work but leave me as a zombie the next day.
Don't let anyone make you feel bad! You're in pain and it's VERY real. If they felt what you do they would act the same way. I hope your husband is supportive of you! You need it.