Thousands of youngsters chase their dreams to top-level football, but few make it. As a result the effect on mental health has come into full focus.