If you meet a professional athlete you'll understand firsthand what drawbacks there are to spending your first 2 decades super specialising.
I don't think the "social disparagement of professional athletes" is with regard to a lack of skill at "what they do", but the sacrifice of what they don't, coupled with a view that what they've sacrificed for isn't actually important.
My views on the matter are mixed.
You can master something without taking it into extremes. It's more going through the ups and downs of learning and experiencing progress and lack thereof.