Sndio builds on top of OSS and they are tightly coupled on FreeBSD, so "sndio vs oss" is a false dichotomy.
Use sndio if you need networked audio/MIDI, need a monitor device to record what is played back, if your favorite application doesn't provide a working OSS or good alternative backend, or...