Controversy-laden film had one of entertainment giant’s most unsuccessful box office opening weekends for a live-action remake