>And like any responsible parents, they presumably also don't just defer to what their elementary aged children "want to do with their life" nor feed into the exaggeration that "everybody else" does anything at all, let alone play tackle football.

This is the only wise position. Despite the common and misleading film tropes, children do not know themselves perfectly. Often the adults "holding them back" are doing those children a great favor.