It's a way for us to make sure we are keeping up with the times compared to other power 5 programs. It's also a way for our coaches to get an outsiders view on what they see at practice, and how that relates to NFL success, college, etc. It's also a way for a us to get our name out there as someone earlier alluded too. So basically what does he do? He consults. It's probably the greatest job in the world because there really is no perfect definition for a consultant.
In my line of work, a consultant is usually someone that a company hires to save themselves the hassle of doing it themselves. In the long run, it saves you money and even more valuable, time.
As far as football consulting goes, I think it makes the game safer for athletes, because there are times of the year where coaches are not allowed to coach players. That can be very disadvantageous to a player, especially someone who needs advice on very specific life needs such as health, safety, family concerns. The players should be able to reach out to him and he should be able to relay from Campbell or whoever the NCAA permits him to be an intermediate for.
Lastly, I am not an expert on this service or any football consulting. This is just from talking to a few coaches here and there about what is changing in the football world. Take it for what its worth(which may be nothing)