Setting a workflow to on demand gives you the opportunity to execute a workflow manually that is normally activated automatically in the background.
This for example allows you to re-execute workflows that require information that wasn't available yet at the time the workflow was automatically triggered. You can then trigger the workflow manually when the field with the required information is filled to start the same process the automatic trigger would have started.