"...the lacking in common sense always seems to me like it should be contradicted by the fact that he's an academic."

Unfortunately, no. High Intelligence and low Wisdom is not, sadly, just something used for a game mechanic. It isn't as common as some people might think - the "ivory tower intellectual" is more a caricature than a representative - but there are people like that out there. I've met a few.