On upsampling...
The purpose of upsampling is to simply enable use of the DAC at its max sample rate to play Redbook CDs. It basically replaces the DAC's digital filter with its own digital filter. The output from an upsampler is a "filtered" Redbook signal at 96 or 192 kHz.
Although the DAC itself is operating at a higher D/A frequency when an upsampler is utilized, since the upsampler *already* filtered the Redbook signal, in the same way oversampling does, the resultant analog signal out of the DAC is no more resolute than more-conventional methods of D/A conversion. (In fact, unless upsampling does 320x oversampling followed by 147x "downconversion" [which would result in a synchronous conversion to 96 kHz], the asynchronous sample conversion will be somewhat "lossy.")
In regard to listener preference of upsampling in a digital rig, it comes down to whether the listener prefers the digital filter in the upsampler or the digital filter in the base DAC. If the base DAC is excellent to begin with, the less-likely an upsampler will improve upon it.
But technically-speaking, an upsampler does not gain anything, aside from giving the listener a choice of digital filters. Unlike some claims by manufacturers, it does *not* improve resolution in Redbook CD playback. (The SimAudio paper got it right, by the way.)
On Aliasing:
An alias is a frequency-reflective image about Fs/2 (half the Redbook sample frequency). In the A/D conversion, a "brickwall" filter is required because if for example, a strong 25 kHz overtone exists *before* digitization, recording *without* a filter would encode an image tone to the CD at just above 19 kHz, which is totally unrelated to the music signal. (Higher frequency tones before digitization would be encoded at even lower frequencies onto the CD.) In the D/A conversion, the images would only occur above Fs/2, and as some here have said, it *could* wreak havoc with downstream electronics if no filtering is used at all. (I think most digital filter-less DACs have some analog filtering to prevent any such problems.)