If we don’t heed Nietzsche’s warning and find the courage to abandon religion, society risks the imperilled and uncertain future painted in sci-fi epic Dune