You won't go wrong with that Ace product of pool filter sand that you linked to.
Would be nice though if it came in other colors than the light brown sand color which Ace usually sells (they normally don't carry other colors, which may be available at pool supply stores, e.g. white, light grey, light pink, several shades of sand/beige color.)
PFS is inexpensive compared to LFS bought sands, but quite frankly that doesn't mean it's inferior, as it will generally have all of the features or more, (with the possible exception of some nutrients) than most of the LFS sands which usually cost a lot more.
If you get #20 or #30 grade density quartz-based silica PFS it will have little or no dust so doesn't need rinsing, the grains will be large enough to not be siphoned out when using a standard aquarium vacuum tool, heavy enough to not free float in the water column when disturbed (so will not get into filters & clog them), easy to keep clean, looks real good, and will grow many plants quite well using nothing but root tab ferts.
That can't be said for cheap play sands & other sands available at the big box stores.
Here's a couple of pics of a discus tank to give you some idea of the look and the variety of plants it grows well.
I use white PFS & have done so for years in my discus & other tanks - wouldn't use anything else in low tech environments.
A lot of the bad things you might have heard about sand is the risk of the development of toxic anaerobic gas pockets.
That usually occurs with play sands which compact very heavily & easily, thus paving the way for this to happen. It also generally occurs when sand substrate is layered quite deeply, e.g. over 3" deep.
IME, this rarely occurs with larger-grained PFS, particularly if it's no deeper than 2.5" -3", which is all you need to grow plants well.
I keep mine approx. 1/2" or less in front in the open free-swimming areas (as you can see in the photo above) and no more than 2.5" at the rear in the planted areas.