The Sandfish's primary purpose is that it is required to complete the Community Centre, specifically the Speciality Fish Bundle within the Fish Tank. Outside of this, the Sandfish make an acceptable (but not great gift) or can be used to create standard dishes (although as it is hard to find, I would perhaps consider making these dishes with a different kind of fish) and can be sold or eaten!