Francis Ford Coppola's self-financed epic Megalopolis flopped, while the acclaimed DreamWorks Animation family film The Wild Robot soared to No. 1 at the weekend box office.