Congrats on the offer!
There are so many other questions raised by your post, I thought I'd address just one concept.
If your son is proball material, and playing at a D1, it doesn't matter whether the program is great, good, or bad. He will be found, and drafted or signed as a FA.