What nasa fuck up do you mean? In my experience most rocket nerds just think SLS is a bad design (Senate launch system is one nickname), and that nasa is continuously hamstrung by politics and budget. The loss of two entire shuttle crews is what I think of first. Those have been studied to death and while there were bad decisions that ultimately led there, the shuttle itself was just an inherently dangerous craft.

It's unfortunately pretty normal for new rocket platforms to experience failures and with rockets almost any kind of failure results in a nexplosion 😆. Falcon 9 had its share of failures (not counting those related to reusability) but it's now a mature design with a very good reliability record.