was I manipulated or is this just an unfortunate situation?

Gonna try to keep this as simple as possible, cause there are a lot of moving parts. Not sure if I'm looking for advice or just venting. But either way, gentle honestly is appreciated as my emotions are pretty tender right now.

My (30sNB) long-term nesting partner, Cloud (30sTF), has agreed to my other partner, Rain (30sM), spending the night at our home every other week. We only see each other once a week, and Rain can't host because they're going through a divorce with a monogamous person who originally said she was okay with Rain being polyamorous, but after years of trying, has realized that she just can't get behind certain things. This was not a polybombing situation. They are just not a match in a way where they can be married.

The overnights at my place are the most quality time that Rain and I get to have. The dates in between the overnights are still great, but limited.

Cloud and I have a young child together, and we have slept in separate bedrooms for about 5 years of our 9-year relationship. We prefer it that way because Cloud snores really loud, and we also just love having our own spaces. So when Rain spends the night, he and Cloud typically only run into each other briefly. I would like to have a more kitchen table dynamic, but we are being mindful of our kid in this situation and don't want to do anything prematurely. Rain has met my kid, but just in passing.

Here's where it gets tricky. Cloud has a lifelong platonic friend, Storm (late 20sF), who needs a place to stay while she goes through a life transition. Cloud asked me if it would be okay for Storm to live with us for a couple of months while she gets on her feet. I was hesitant at first, knowing that the sleeping arrangements would have to be shuffled around. But ultimately, we figured out a solution. Cloud will sleep in my room with me, Storm will sleep in Cloud's room, and our kid will have their own room still as always. I told Cloud that it's really important to me that Rain and I get to still have our overnights while Storm stays with us, and asked what we would do for sleeping arrangements on those nights (which happen 2 days out of each month). Cloud originally said (enthusiastically) that she would just sleep on the couch when Rain is here. That she still wanted Rain and I to have our time and realizes how important that is to me. She was supportive and lighthearted.

So after this conversation... I agreed to Storm coming. This was 2 weeks ago. Fast forward to today, Rain and I are supposed to have an overnight tomorrow. I ran it by Cloud again this morning just to double check and she flipped out. She said she feels disrespected and that she doesn't want to sleep on the couch and "must have been trippin'" when she agreed to that. I would not have agreed to Storm coming here if I knew it meant I'd need to give up my nights with Rain.

Cloud is saying that Rain isn't doing enough to make space for me in his life. But even if Rain could host me at his place with Snow, we would still probably be here every other week. And we'd be at his place during the other weeks.

I'm frustrated. I feel manipulated. I feel like Cloud knew deep down she wouldn't wanna sleep on the couch while Rain is here, but she wanted me to agree to us helping out her friend, so she just said what I wanted to hear.

We've been going back and forth about it all morning. And I've communicated my feelings to her. I've also told Rain about Cloud's new feelings about the overnights. And Rain said he would ask Snow again if we can hang at their home. I told him that I wasn't necessarily asking for that, but appreciated him wanting to try. Snow will probably say no.

Am I just settling for crumbs from Rain? Is Cloud in the wrong here? Am I in the wrong?

I realize this is all kind of messy. I don't want to end things with Rain. I really love him and don't just want to give up. Neither of us can afford to do weekly or even bi-weekly hotel stays as we both are the support person at our homes and primary caretakers of our children.