Not true at all.
So....the 'career' usually starts at about 6, 7 years old. That involves travelling every weekend, extra training during the week, being unable to do sleepovers etc, watching diet, unable to do certain activities like skiing, not being able to go on holidays with family, if they have siblings in school ( pre season clashes) trying to juggle academia with training priorities.
Thats aside from the mental pressure, not being able to socialise with peers, knowing you could be released at any point, knowing people could try to attach themselve due to the job etc.
Then out of all that, a very small percentage make it to the wages i think people are talking about. A lot more get slowly discarded through lack or ability or mental strength, and when their whole identity has been as a 'footballer' from childhood, its hard.
Only if they make it 'big' may there be insurance that kicks in, but thats probably after 15 to 20 years developing. Anything other than the top couple of leagues isnt that substantial. Make it to those levels and yep, its worth it. 99% wont do though. Then they have a limited shelf life based, that could be dictated to by the whims of a manager. One lad i know was ready to debut at a young age against premier league club, got injured, then change of manager with different tactics and he never played for them again. His counterpart from the time plays for England and premier league now. Literally one wayward boot and a domino effect ruined his career. And no insurance payout.
Its easy to judge from the outside, as with most things, in real life, its not that clear cut