Using soul sand or soul soil to make the soul campfire doesn't change anything about how the campfire works. However, it does change the normal color of fire to a cyan blue.

The campfire, new to the village and pillage update, creates smoke that brilliant people in the community have been able to manipulate to create Typewriters or smoke signals.