Your sand dissolves in citric acid because it is carbonate sand.
Not all sand is formed by quartz, even if it is usually implied in context of masonry or fish-keeping. There are sometimes used explicit respective expressions for "quartz sand" in some languages.
The term sand does not describe what the material is, but how the material looks like. It means solid, water insoluble "stoney" material, consisting of loose particles with the particular range of granularity $\pu{0.05 - 2 mm}$ (credit to David S).
Quoting the Wikipedia:
Sand is a granular material composed of finely divided mineral particles. Sand has various compositions but is defined by its grain size. Sand grains are smaller than gravel and coarser than silt.
Sand can also refer to a textural class of soil or soil type; i.e., a soil containing more than 85 percent sand-sized particles by mass.
There are beaches with bright, near white sand formed from shells. It is based on calcite/aragonite $\ce{CaCO3}$, soluble in acids while releasing gaseous carbon dioxide.
$$\ce{CaCO3(s) + 2 H+(aq) -> Ca^2+(aq) + H2O(l) + CO2(g)}$$
There are beaches and deserts with dark, near black sand formed from various volcanic rocks.