Keep in mind there are 2 axes.
In the time domain, you're absolutely right, Nyquist–Shannon proves that we don't benefit from sampling higher than twice the upper bound of human hearing. Rates like 96kHz or 192kHz are useless for quality (although in specific live situations, they have utility in that the latency would be half or quarter that of typical rates, for a given buffer size in samples).
In the amplitude domain, CD quality (16 bits/sample) is pretty damn great for typical mastered audio (~96dB undithered, ~120dB dithered) but if the audio is unusually dynamic (i.e., loudness is not maximized) like with a symphony orchestra, you might actually turn up your sound system to the point where quantization noise becomes evident in the quietest parts, at which point you absolutely would benefit from more bits per sample (say, 24, yielding ~144dB of range undithered).
So in practice, you're right, CDs are fine; but "humans can't detect beyond that" only truly applies in the frequency domain. We can detect latency (not applicable to playback of recordings) and we can detect quantization noise when cranking up the volume knob.