SACD makes sense for one genre of music - classical. The SACD catalog is deep and diverse in this genre. Also, much of it is 5.1 multi-channel (MCH).
Digital downloads and streaming (Tidal, etc.) are indeed on the upswing, but they still trail CD sales, and there are very few MCH digital downloads. Digital streaming in stereo may someday include embedded 5.1 via DTS Neural, but that has not happened yet.
Also digital downloads are still primarily a US phenomena - much of the rest of the world is still wedded to the silver discs which are cheap to make, not vulnerable to power or RAID failures, and not dependent on fast Internet connections. Considering all of this, if I were a classical fan I would have two "antique" devices in my rig - a vinyl turntable, and an SACD player. (Since I am, I do !)