I agree with pike1 - there is good red sand and not so good red sand.
Some of the red "sand" I have bought in the past has been more like dirt - rock hard when it dried. Also stained everything. I got some real desert sand from a friend which is much better and cleaner but not so great for burrows.
I guess it depends on what you are buying.