Wikipediahas a fairly good description, as well as other examples of coaches who have been hit with show cause penalties. Short answer: yes, he’s effectively been banned from coaching at the college level.
I’m having a hard time finding information on the history of the penalty, but it was my impression (although I could easily be wrong) that the intention was to prevent another Jerry Tarkanian, where all three of his NCAA teams were hit with major rules violations.