Even “The Rock” couldn’t prevent the worst Memorial Day weekend at US cinemas in nearly 20 years