I believe this is the same as play sand. If so, then...
Pros: inexpensive , natural color(s)
Cons: very dirty (requires a lot of rinsing prior to usage), irregular size/grade, lighter particles prone to getting sucked up by the filter when disturbed.
Once you get past the rinsing part, it's fine. If I were to use sand again, I would look for pool filter sand; uniform grain size, tends to sink when disturbed.