Rosamund Pike says Dwayne Johnson film is “one of the worst" she ever made and nearly ended her career