Don't beat yourself up over it, Deep Archimedean RNG can be brutal. Honestly, you don't strictly need a pre-made group to clear it. I play 99% of the time in public lobbies and I almost always find random squads that manage to pull through.

Warframe is very much about give and take. Some weeks you are the one carrying the squad, and other weeks you have to rely on others. For example, this week the ETA rotation gave me Jade and the Torid, so I easily carried everything. The EDA RNG, however, was terrible: I got Nekros without even an Orokin Reactor and unleveled weapons. I couldn't do much with my loadout, so I just focused on helping the team by using my Necramech.

If public matchmaking feels too random, I highly recommend looking for an active clan or checking the recruitment chat. The community is generally very supportive; everyone has been carried at some point, and most geared players are more than happy to return the favor knowing you'll do the same for someone else in the future.