Of course few get great. Even if you don't get to great, many people make a satisfactory amount of money from chess (mostly teaching), so there are options.
Also, you can switch at any time when you realize how hard the competition is. Your study habits to get good will do you well in other positions so there is no loss failing so long as you get out soon enough. There is a reason many pretty good players quit after high school: they had fun now it is time to settle down. Some play once in a while, but it is no loss. Unlike boxing where a few knockouts and you may be mentally unfit to do anything with your life.
[0] https://en.wikipedia.org/wiki/Magnus_Carlsen#Personal_life
[1] https://en.wikipedia.org/wiki/Joshua_Waitzkin#Martial_arts
Also I would claim that talent is domain-specific insofar that very few people have a mental and a physical talent at the same time. For instance there are professional athletes who are very good in some other sport but I know of no one who is also very good at chess.
Emanuel Lasker was iirc a very noted mathematician. As I mentioned, this is from memory. I’ve known a person who had both made the national swim team as a 19-year old, and was a national bridge champion in his thirties (not in the US).
I don’t know to separate talent from work ethics, but my layman’s impression is that that these aren’t simple, and definitely not independent, measures across fields.
Judit's level and achievements were due to training and persistence.
Also the Wikipedia page says she was a "chess prodigy". From my personal experience I strongly doubt that you can make every five year old child a chess player who wins blind matches against grown-ups only through hard work.
And the "youngest grandmaster" title simply keeps moving downward, so apparently you can convert random 5 year olds into chess experts.
I really don't understand why people still cling to the notion of "talent" in intellectual pursuits. It's pretty clear that "number of hours" is what places you in the top echelons.
Only the very top 0.5% get name recognition (money). And like Boxing, these athletes could get paid more had they devoted their life literally ANY other pursuit with their work ethic and talent. With far less punishment involved.
Concept of Talent Stacking: https://personalexcellence.co/blog/talent-stack/