As snickle-whazit points out, the spikes will modify the frequencies at which the resonance is transmitted to the floor, though you are right, not eliminate it. (sorry, I wasn't clear) The amount of energy transmitted is not reduced, but how it is transmitted is modified. Certain frequencies may be increased, while others decreased, which may or may not be a good thing depending on the particular frequencies in question and whether or not resonance is actually a problem.
There is also a factor of cabinet resonance - decoupling means the cabinet loses some of its own resonance to the decoupling material, and some speakers rely on that resonance to achieve a particular sound. This will tend to show up in the mid to bass regions.
As I said before, response of the speaker itself is not really changed with a spike. Spikes maintain a solid connection with whatever the speaker is being coupled to, but there is definitely a modification of the transmission of sympathetic resonance at a given frequency to the floor (generally in the case of a wood floor). The only problem is pretty much no way to figure out what frequencies will be exaggerated or attenuated.