12 year old me playing D&D: "What is the purpose of having separate intelligence and wisdom stats? They are the same thing!"
Older me: "Oh."
Older me: "Oh."
Wisdom: Should we really be removing this fence?
Wisdom: It does not belong in a fruit salad
The opposite (smart but not wise) would be someone who is book smart or even a smart-ass. Probably coming up with all sorts of crazy and interesting ideas, but doesn't necessarily judge situation too well and might quickly discard simple but effective solutions. They might be quick minded and suddenly do high risk/reward kind of moves that either save the day or fail spectacularly.