i'm not familiar with wwe, so i looked it up.......and yes, i see what you mean
"spear tackle" terminology in football i believe originated in rugby (both union and league) and here it is where the one tackled is lifted, turned upside down (to some degree, usually greater than the horizontal), then dropped or driven (like "spear") to the ground. A very, very dangerous tackle which can lead to concussion, broken neck or paralysis. this obviously is very different to the term used in wwe