I believe in supertweeters, because I know, from personal experience, that auditory ability exists well above the frequency at which you can detect the pure sine wave that is used for testing.
However, I think you may be on to a point about CDs, and their 20KHz limitation. Some LPs can go a bit higher, but there is some argument about how high, and it certainly varies a lot between different LPs. If there is no signal at 30KHz, a supertweeter good to 50KHz is just an expensive paperweight. Probably the best application for a supertweeter (apart from some very exceptional vinyl systems) would be a SACD or DVDA system, where there is no doubt about the ability to have signal above 20KHz. Of course, the recording equipment must be good enough to include this signal.
However, I think you may be on to a point about CDs, and their 20KHz limitation. Some LPs can go a bit higher, but there is some argument about how high, and it certainly varies a lot between different LPs. If there is no signal at 30KHz, a supertweeter good to 50KHz is just an expensive paperweight. Probably the best application for a supertweeter (apart from some very exceptional vinyl systems) would be a SACD or DVDA system, where there is no doubt about the ability to have signal above 20KHz. Of course, the recording equipment must be good enough to include this signal.