I played football in high school & college. Did I get hurt? Yes. But I also got hurt in other sports. My worst injury by far was in baseball (it required ~22 stitches & I couldn't see out of one eye for a while).
With every activity there's a tradeoff with risk.
Let's say we take tackle football off the table. We ban it from high schools, justifying it based on a study showing it produced 3.96 injuries per 1,000 practices or competitions & 8.22 concussions per 10,000 (the highest for both).[1]
Okay, but then do we also ban woman's soccer?
It's the second highest, at 2.65 injuries per 1,000 practices or competitions and 6.11 concussions per 10,000.
Or why let our children take any risk?
As a parent, I know I can't shelter my children. They have to take some risk. I let my children ride a bike, knowing full well there is a non-zero chance he could get by a car. We live in a big city & I let my pre-teen walk to meet a friend at a local burger joint for lunch, knowing full well there are bad people in the world who might do something untoward to him.
As for CTE specifically, I am very concerned about in the NFL. I have mixed feelings if I'm complicit in things by watching. As a diehard Bears fan, I found Dave Duerson's story heartbreaking. I'm supportive of the guardian helmets and hope the league starts to mandate them.
But the athletes in the NFL are not like amateurs. They are far bigger, far stronger, far faster. You can't take the CTE data from professional & extrapolate it to high school, etc.