I was pondering the other day why the best performers such as Nobel prize winning physicists, best
mathematicians, and so on, do have somewhat high, but not truly
exceptionally high performance on the IQ test and similar tests, while some of the ultra high IQ individuals, or ultra exceptional childhood SAT solvers seem to be smart, but for the lack of other word, not really be that smart or wise or capable as the scores would suggest.
The on-going Olympics provides a clear analogy. The best sprinters will not be the best marathon runners; former have large fast versus slow fibres ratio and metabolism geared more towards anaerobic performance, whereas the latter have primarily slower fibres and metabolism geared towards aerobic performance. Past certain level of exceptional performance, there could be very little overlap between the exceptional performers in those two related, but different sports. Note that the best sprinters will still run marathons a fair bit better than average man, and best marathon runners will still sprint better than average man.
The brain is a fair bit more mysterious organ than the muscle, and we understand it very poorly, but it is the case that there are several well known variables that would represent a trade-off between different types of performance. For instance, glia to neuron ratio. Glia are the support cells that provide nutrition to neurons as well as remove the metabolism by-products of the neurons; furthermore glia have been recently found to be implicated in the memory.
Glia to neuron ratio should influence the cognitive performance, and it appears highly unlikely that the optimal ratio for the tests would precisely coincide with the optimal ratio for the insight making or the real world performance. There are many other such trade-offs within the brain. Hormonal levels, thickness of myelin shealths, short range vs long range connectivity, gray matter vs white matter... you can continue this list for pages.
The short term tests consisting of large number of disjointed questions which do not involve a significant body of learned knowledge (outside verbal, which represents a highly specialized brain region and very special type of learned knowledge) seem even more distant from insight making or long term work than sprint is different from a marathon race; I would expect even less of an overlap between exceptional performers on the criteria there. The relation may be more similar to that between grip strength and biathlon.
With regards to the childhood testing, it seems clear that exceptional childhood athletes at age 10 would have variations (Various hormonal dis-balances?) that are detrimental to the adult performance.
Note that none of this argument contradicts existence of correlations. Bulk of measured correlation comes from the values close to the mean, and it is the case that all the exceptional performers at age 20 were very good at age 10. Just not as good as the phenotypes which make use of the trade-offs.
edit: See also:
Spearman's law of diminishing returns ; among the high IQ range, the correlation between different traits decreases. It is thus not surprising that at high IQ range, the correlation between the skills implicated in IQ test and skills implicated in, for example, theoretical physics, would decrease.