I failed a mandatory course in my undergrad, and my life feels ruined alongside my grad school dreams

[nyc_1999]

I am a U.S./Canadian senior mechanical engineering student, studying at a Canadian university. I have been very fortunate to intern at 3 NASA research centers and also obtain a publication too. All my recommenders for grad school were NASA PIs, and I am also a candidate for the GEM Fellowship. I applied to 19 M.S. programs (including Columbia, MIT, Yale, Princeton, NYU, UCF, etc) and although some may be cash cow, as a GEM Fellow these could be funded through an employer or associate fellowship. I have a mediocre GPA (3.3) but still received acceptances to 2 of the 19 schools, with others having pending decisions. Unfortunately, I was writing an 80% final exam due to me deferring the midterm because I was very sick, and I ended up failing the exam and the course by a lot. I fell into a deep depression, and now I have to let my family know, my NASA supervisors, and the schools that accepted me know that I can't attend grad school in Fall 2024 because I failed. I'm so disappointed in myself and I don't know what to do. I know grad schools defer under extenuating circumstances, but I don't think failing counts, plus the fellowship is tied to start Fall and there's no guarantee I get it again next year. I also can't take the failed course (which was electrical systems, a mandatory course) until Fall 2024 due to it not being offered in the Winter or Summer semesters. I don't know what to do and have had my mental health hit an all-time low since yesterday. I would love and appreciate any feedback or advice? I don't mind going to a state school or lesser known school for master's with a deferred admission to Spring 2024 and a TA/RA-ship, I just feel like a failure rn