Agreed, but wouldn't total heating (resulting in tweeter destruction) be a function of RMS energy, time and dissipation? So the more time the sweep spends above crossover (and assuming a flat tweeter impedance curve, which may not be right) the more heat would be applied to the tweeter. When time and RMS energy result in more heat than the tweeter can safely dissipate, out she goes.
Considering the issue of why the OP toasted tweeters with an REW sweep, but not program... With dissipation held constant, either RMS or time or both had to change. I don't see in his data that he used a 256k log sweep, it might have been longer, and level seems undocumented other than an AVR volume setting, so we don't know. But for a given RMS level and a log 10-24kHz sweep, wouldn't tweeter heating be a function how much time that sweep spend above the crossover where the energy would be applied to the tweeter, along with the specific level of RMS power applied?
Yes, I understand RMS is difficult for signals that vary over time, but depending on the thermal time constant of the device being heated (and tweeters are actually fairly short), we might be able to integrate over that time constant, perhaps a bit longer, and get a feel for what kind of heating a given signal causes. For example, take the pink noise from REW as compared to the portion of the 10-24k 256k log sweep that lands above 2.5kHz (which lasts about .35 seconds), and analyze that for heating capability (RMS). We land at an arbitrary -12dBFS for the sweep because that's the level of the signal and it's amplitude doesn't change with frequency. So that's .35 seconds of -12dBFS RMS. Now take a sample of pink noise .35 seconds long, generated also at -12, but filtered at 18dB/octave below 2.5kHz to represent the portion of the signal applied to the tweeter. We get -17dBFS RMS. So -12dBFS pink noise applied to the speaker for the same time as the sweep in this example applies 5dB less RMS energy to the tweeter, and correspondingly less heating for the same amount of time. The sweep's spectral distribution may match pink, but I don't think tweeter heating is particularly spectrally sensitive, it just gets heated by any RMS energy applied with much less regard for frequency, up to some practical limit of course.
Now we would have to consider the dissipation of the tweeter and its thermal time constant, we could then generate 3 axis graph showing time vs level vs heating and perhaps even superimpose a fatal threshold for some given tweeter. I wouldn't bother to attempt generate the graph, because it would be very specific to a given tweeter and full data may not even be available. but clearly the combination of level and time (as applied with respect to the tweeter's thermal time constant) would affect where along the curve any signal would land with respect to tweeter fatality. And the REW sweep signal likely contained more than one chirp, with less than a second of cooling time between high frequency heating energy applications, possibly pushing up higher on the thermal time constant toward the destruction point. Of course, we don't have the actual time constant, so I admit to this being conjecture.
Music, particularly above 2.5kHz, is less constant resulting in far less RMS energy over a typical tweeter thermal time constant interval than a continuous sine wave, swept or not, for the same interval, likely less even than pink noise. My theory here is that the extra energy from a sine wave constant amplitude sweep, with the possible Audyssey 8dB boost as a factor, is what cased his tweeters to blow with the high power sweep when program material didn't blow them.
I also recognize there isn't enough data here to be sure. We don't know specific power levels, we don't know what overall gain offset Audyssey put in place to meet reference cal, and we don't even know what sweep rate was used for certain, though likely the default. And .35 seconds does seem to short to blow a tweeter, but it certainly did. All I'm trying to tune into here is the delta between the sweep energy and program or pink. Seems like there may be quite a bit more in the sweep than we think. And then apply significant power, clearly too much, with burn out as the result.
And yes, I'm overthinking all of this.