I haven't really subscribed to the "people will stop playing football" point of view, but this just hit the news.
Repeated head trauma causes brain changes in young athletes before CTE symptoms
At some point, youth sports has to be dialed back. It used to be casual, now all these parents are making it hyper competitive.
NFL will still lead the way, college football too. College hoops is hard to project. I think the NIL and money angle has a much bigger influence on a 13 person team than on a football team with 80-100 guys. They have to figure it out. The Euros are coming for it too. MLB is fine and may have a resurgence if they can fix the imbalances. NBA needs some help to focus on the actual game instead of flashy highlights and star power. It has lost its way. NHL is rock solid, but the ceiling is low. Soccer could see a benefit if people shift from "contact" sports, but the reality is that heading soccer balls is probably not ideal for CTE, we know it is very bad for young girls.