like full frontal stupidity?
No, not the same thing at all. A spoonerism is the transposition of sounds at the beginnings of words, such as “blushing crow” for “crushing blow”.