James McConnachie finds that theology and geology have been unlikely bedfellows for centuries