Ron Howard's ocean epic In the Heart of the Sea has flopped at the US box office, making just $11m (£7.25m) after debuting in more than 3,000 cinemas.