Also, there are several kinds of asbestos fibers (broadly serpentine and amphibole), and the most lethal kind seem to be present typically as only a small fraction. Which makes it harder to relate risk (typically in units of f/mL.yr of a specific fiber type) to occupational exposures (often, AFAICT, in units of f/mL.yr of mixed fibers).
I suppose some of the horror stories about insane cancer incidences are from areas with peculiar asbestos deposits. Most of these studies I found were looking at averages of various cohorts (based on occupation, mix of fiber, etc), so wouldn't reflect those peculiar environments. Which I think is fair when comparing to CTE, otherwise you can cherry pick to exaggerate or minimize the relative harm of CTE. Ultimately there's a limit to the comparison.
But be skeptical. I'm gleaning this from some some quick Google searches and a superficial parsing of research papers, trying to create a 10,000' picture from claims and statements that are couched in very specific and narrow terms.
The subtext was, "even asbestos removal has a lower risk of health problems than football".
But I think that comparison may be confounded by the fact that the modern asbestos removal profession is organized around safety. In other words, that asbestos removal is not a good comparison point for high-risk professions.
I'll note that the "lifetime risk" numbers in the first response are almost certainly historical. I'd expect the studies he's looking to have been published around the time modern handling standards were developed, and they may have even contributed to their implementation. The symptoms also take decades to manifest, so I'd expect modern rates to be good indicators of the safety of the industry circa 20-30 years ago and nearly useless for indicating modern standards. 50 years ago probably not, but 20 years is probably still good.
But suffice it to say that, surprisingly, AFAICT for even exceptionally heavy occupational exposure (e.g. mining asbestos or removing asbestos insulation) lifetime risks of developing mesothelioma seem to be well below 10%, and possibly even below 1%.