The Smashing Machine marked a big shift in Dwayne Johnson's acting career, but it set a disappointing box office record in its first weekend.