The belief that science and religion are in fundamental conflict runs deep. But is it really as simple as that?