I used Black Tahitian Moon Sand in a 40 usg for awhile. My cories were fine with it. I'm sure they liked the change to sand from flourite. It all eventually got mixed together with the Eco Complete Planted Aquarium Substrate in the 100 usg when I set that up. I put spectra stone in the 40 for the goldies.
Straight sand has some issues. It compacts. I assume the moon sand does too.
When it compacts it traps toxic gases that must be released by stirring the sand. Some use snails for this and Malaysian Trumpets esp.
Of course the other is that sand is light and stirs up easily and floats around.
I have planted tanks. I hate to wash sand. I will often NOT set up a tank because I hate it so.
I use Spectra Stone in unplanted tanks. It only is rinsed/no heavy silt.
So I now use in a planted tank a mix of First Layerite (small amount so easy to rinse), Eco-Complete Planted Tank (not to be confused with Eco-Complete Cichlid), and commercial grade 30 grit Quickrete, a medium weight builder's sand that has been steralized. I don't even wash it.
This mix is satisfactory for light planting. I use Trumpets and plant food.
The big tank has a dark rich dirt-like substrate, with red flourite like bits. The moon sand has mostly fallen to the bottom. The cories, clown loaches, otos, BN are quite happy with it. No one has barbell issues.
Your cories will like the moon sand as long as you keep it clean. Of course THE corey lady is Inchworm.