Sand isn’t round enough, nor are most grains clear. You’d need perfect clear quartz beads.
And then the index of refraction would be different, so the rainbow would be all messed up.