"The Bible is one of the worst books ever," says Brian Cox because "it is not the truth"