Pictures how a single cycle of a 10KHz sinewave (the black line) is sampled at CD rate (44,100 samples/second, 5 samples) and at DVD rate (192,000 samples/second, 20 samples).

At 44,100 a sinewave with frequency 22,050 is sampled at only two points per cycle! At frequencies slightly lower than 22,050, each cycle will be sampled at a different point!

CDs sound pretty good but you can see how frequencies at and above 10K aren’t going to be reproduced very well. Their relationship with other sounds in the mix will change, and since human hearing is sensitive to phase distortions, the result won’t sound as good as it could with the DVD-style oversampling.