To word my last question more clearly, did I screw up or not?

Where did you apply to transfer? Did you work with the transfer advisor at your community college to craft a list where you had a good chance of acceptance?

It seems to me that the only mistake you made was that perhaps you just aimed too high and had no good possibilities for admissions on your application list.

I’m linking your other thread here for context. You are getting the same answers here.