DC Studios' Supergirl faces a staggering $100 million loss, highlighting critical missteps in storytelling and marketing that undermined its potential to resonate with audiences.