Disappointing recruitment--why wasn't I chosen?

Here's what I hope will be the short version. I'm a sophomore at a smaller public university with relatively laidback recruitment (at least compared to schools in the south). I decided to rush this year and people have told me I'm perfect for a sorority. I'm involved in a lot of activities, love volunteering, sports, music, etc., and [I'm not trying to be full of myself] am prettier than your average girl. I'm a legacy at two different sororities on my campus, my dad was in a fraternity, and was really looking forward to going through rush and finding my place in our Greek system. I had two letters of recommendation for one of the houses where I'm a legacy, and the women in my family have been so excited at the thought of me joining a sorority, as have I!

My recruitment walkaround group was all freshman except for myself, but we all got along really well and had similar sororities that we liked and didn't like. We even talked about how all of us were such great girls, there was no way any of us would be mismatched.

Our first round, we had short parties at each of the ten houses. I felt that it went really well; I had a bunch of great conversations and really clicked with a lot of the girls I met. There were two houses where I really couldn't see myself at all, so when we did our rankings, they were at the bottom of my list.

When we got our parties back for the second round, I had been cut from three of the houses where I thought things had gone great (I loved them!) and so I had back both of the houses I had wanted to drop, for a total of seven parties. The second round was AMAZING. At two sororities I had really wonderful experiences, great conversations, and really felt like I found my place. I was worried about having to choose between those two houses towards the end. There were two other houses where I didn't have such awesome experiences, but I felt like I just needed more time to get to know them. When we ranked, I wanted to drop the same two houses I had tried to drop the first night; nothing had changed in my experiences there and I didn't feel like they were for me. There was also another house where I had an okay experience, but it just didn't feel right. So those were the three that I ranked at the bottom.

Then when I went back to get my party schedule for the third night, my Rho Chi looked at my schedule and said "I think we should go outside". She showed me my schedule. Somehow I had gone from seven houses the night before to ONE HOUSE. One house the night BEFORE preference night. We were supposed to have three to five houses. And of course the one house was the sorority I had ranked last both of the first two rounds; I felt no chemistry with the girls and was just straight up not interested in that house.

I started crying, and my Rho Chi tried to comfort me by saying how she didn't know why it happened, she could really see me in some of the houses I had wanted, sometimes the computer screws up, and so on. I made the decision to drop out of recruitment, because I knew I didn't want to join that one house that had asked me back. They are a small house and really trying to increase their numbers, and maybe only asked me back because of that!

So I filled out the drop form and left, really embarrassed that I had been a mismatch, and totally distraught that I'm not going to be finding my place in the Greek system here.

There is the very slight possibility I could be offered a snap bid, and some of the houses may do spring recruitment if they need to fill the house, but...I don't know if I would try again to join houses that didn't want me this time around.

I want to know why this happened. I am a normal girl-there's nothing weird about me, I love having fun and hanging out with friends, shopping, the beach, and so on...so why did the sororities that told me how much they loved me, that really seemed like they would fit, not ask me back?

I guess this all means I'm not meant for Greek life, but I'd still like some opinions. I feel totally demoralized by this experience.