With recent examples of high-profile atheists publicly converting to religious faith, or aligning with ‘cultural Christianity’, it seems the tide might be turning against secularism