Isn't this just Berkson's paradox? If you filter for either exceptional childhood or exceptional adulthood they will appear negatively correlated.