Getting IB job with Academic Code Violation ON TRANSCRIPT? Am I done for?

So, I messed up. Some background, I'm a current sophomore at an ivy studying economics. I had a PE internship last summer and a BB IB internship this summer (online now, think lower level BB though). I have a semi-solid finance network, I'm diversity of a sort, I'm going to be president of an investment group on campus. I've got an ok GPA, 3.6-3.7

I cheated on a test, got caught. I went through the process, guess the COVID situation didn't change their lack of sympathy. I had some extenuating circumstances, they didn't care. The hearing outcome is both that I fail the class (harsh) and that on my TRANSCRIPT it says I failed the class because of violating the academic code.

I know this situation is bad. My mindset's gone from gunning for top-level IB or the like next summer to "I don't know what the fuck I'm going to do oh god." I messed up, this wasn't a good semester for me. But this shit is competitive as hell, I know. And this seems like an easy way to get auto-dinged from the best places at least.

My hope is that I can get an offer from my BB IB internship this summer, which isn't unlikely. I work my ass off the next two years of college. I don't have a goddamn clue what else though, or if even this is unrealistic.

Please be frank, but give me advice.