I love watching football, have ever since I was a kid, and I think a lot of the pearl clutching over concussions and head injuries is mostly virtue signaling. The game is as safe as it ever has been. Despite finding out more about concussions and CTE in recent years I don't think anyone was under the impression 20 years ago that football is a "safe" game or that concussions don't have long-term consequences.
Having said that, I have come around on the notion that 100 years from now people will look back and wonder how football was ever a "thing." Kind of like how we react today to hockey goalies not wearing masks. They'll wonder why guys were willing to put their bodies through that, and at risk of grave injury, despite the money that was being made, and they'll wonder why we celebrated it as a society. It will absolutely be looked at as our generations' gladiator games.