Feel Awful 😟

We are at my mother-in-law's for the weekend with the baby. We have stayed here numerous times before. However, for whatever reason, baby was up ALL NIGHT last night. No one got any sleep and there subsequent day was exhausting. So tonight, upon his first waking, I tried to let him cry it out... Checking on him every 2-3 minutes, rubbing his belly/back. 25 mins later and we were still melting down. So husband says we should just tough it out again tonight. Now I'm holding him in a chair and the whole crying thing was for nothing! I just feel like a terrible Mom. Basically put him through the ringer but couldn't follow through 😟😵