If he's driving and we get pulled over for speeding, is it illegal for
him to not be on the rental agreement but be driving?

No

Also, God forbid he has an accident while driving, what're the
repercussions of that?

You just had ALL the car/damage charged to YOUR credit card and
...also the damage and injury to the other vehicle /passengers too since you
are uninsured