Even The Rock’s star power wasn’t enough to deliver a box office win for DC