Supergirl failed at the box office because most people who still go to theatres are older people resistant to change and young people who want to act obnoxious in public. Both skew conservative, so a movie with "girl" in the title and starring a girl they don't want to fuck is too woke for them.