I would definitely test it out first to see how red it's going to look under water and your lights. Aesthetics is a personal choice, but generally black or light tan substrate contrasts best with plants and having a red substrate might take away from that. You also have to make sure it's going to look good with any hardscape you might be using.
Also dark substrates are much easier to keep "looking" clean since they won't show waste as easily or get discolored the way very light sand would. Pool filter sand (PFS) is a very good substrate, but the top layer will discolor just from bacteria growth regardless of how well you keep up with maintenance. One good thing about PFS, you can just vacuum out the top layer, clean the glass a bit and poor new sand in, since it's extremely cost effective.
I've done plenty of tanks with both light and dark sand so depending on setup sometimes the plants and fish color will pop more with black, but as I said light color sand in some setups looks amazing.