Community College Sophomore Internship - Is it possible?

Good Evening Monkeys, I’m currently a Econ major at my Community College with a 4.0 GPA, club leadership, deans list, etc. etc. The works. Planning to transfer to a target this fall or else I’m going backpacking across S.E Asia. The issue is in my school name. I know everyone, from the M&A bigwigs down to the administrative assistants, are going to sneer and spit at my application once they see “Community College”. Choosing a 2.3 GPA (functioning alcoholic) communications major from Yale instead. Knowing this limitation i’m pretty discouraged on even finding a sophomore internship. I tried Freshman year, sending out 400+ cold emails from everyone at boutique firms and search funds but the majority of them just were completely ignored. I think I legitimately messaged one firm in each state of the U.S. and in every major city. No responses at all, other than some faux-polite rejections. I was able to scramble together a research assistantship for economics freshman summer through more cold emails at a T25 school but I never got a true internship. (not complaining, it was a great experience and I loved it) I’m just wondering if history will repeat itself. Fellow community college monkeys, what did you do to secure your Sophomore internship. Am i being too unreasonable? What should I do or look for to maximize my chances? Do I need a fundamental change of strategies? Do I just give up until I transfer? Thanks a ton 3