I watch a lot of college football and when they first adopted the rule you had a load of targeting penalty's because players were still leading with their helmets like it was a missile. But over the years those kinds of tackles have been reduced dramatically. Now you see payers using the shoulder aimed at the center of body mass. For me it has been a welcome and very visible improvement in the college game.
For what it's worth I asked AI abut the college targeting rule and injury's:
Yes, college football targeting rules have helped reduce injuries, particularly concussions, though the data is not definitive and some studies show a higher risk of concussion on plays where targeting is called. Studies indicate that since the rule's implementation, there has been a decrease in concussion rates, especially in high schools. While the rule is intended to protect players, some research suggests that the plays most frequently called for targeting are also more likely to result in a concussion, which may indicate the rule is identifying dangerous situations rather than preventing them entirely.