@Bestyearever2024 I'm with you on this.
Im going to say the unsayable - I bet a man would style this out and would probably be given a caution, whereas a woman takes the full force of the punch and beats themselves up, putting all the onus on themselves.
It's a fine balance, between not pointing fingers at others, but also recognising the context at the time: limited experience both them and their supervisor who was also meant to be the "checks and balances" person. - I'm thinking why have the supervisor checking @BumbleBumbleBumbleBumbleBee work, when even they didn't spot the erroneous recommendation to pick "the right option".
It's good that you're not going to resign over this, OP, hold your nerve, stay calm and see how it plays out. Also, think about what you can learn from this. Ones biggest errors in life are also the ones to grasp and use to help you improve. You have great skills, you are qualified for the job.
I'll leave you with the thought - why do organisations take out professional indemnity insurance? It's because people are fallible humans, and they need a safety net in case of this type of situation. It makes me wonder if your employer holds this insurance and whether they will be claiming on it, if there financial loss involved....