DC Studios' 'Supergirl' faces box office disappointment, sparking debates over misogyny, creative issues, and audience fatigue.