I'm going to throw this out there- Covid alone led many people to experience depression, most for the first time in their lives. During this time period, not only did the entire staff have to adjust everything they were doing (essentially becoming powerless to recruit, host team practices, improve the team in general) but Frost was also clearly struggling to find the success he envisioned in his DREAM job. Have you ever been stuck in a situation where in spite of everything you do nothing goes right and it all seems out of your control? Frost tenure all the way back to the Akron game and into the Colorado game when Martinez gets hurt goes like that. A compounding issue for depression. Then his dad dies. Who hasn't experience depression after the death of a loved one? Add in the stress of needing to be present to help a spouse with a baby and that's a Mountain of stress all with potential depressive results. This would explain the rumors of family problems as well. I can imagine discussions at home about the wife needing more help with the baby etc. Drinking is a form of self medication. Depression would also explain the disheveled look at press conferences and the short answers as depression brain fog sets in.
I am not a psychologist- but have suffered through depression myself when experiencing some of these very same factors without the weight of being the highest paid state employee, managing the states number 1 obsession in the most public way, in my dream job. I was stubborn thought strong people didn't need help and refused it until my wife didn't give me another option. I can imagine Frost being the same. IF- and that's a big if- Frost is going through the same, I hope that he has found or does find the help he needs. The feeling that your whole life is falling apart (even if it isn't) isn't a good one, and its a scary place to be. Knowing the whole state is gossiping and spreading rumors about slip ups you made while struggling mentally could totally be a compounding factor. I'll add when you're a "problem solver" with depression you think you can find your own solutions, when they each fail, one by one, it feels like quicksand dragging you down even further.
I wish Scott had taken this job 10 years later, with his kids more grown, less stress at home, and covid behind us- I bet he does too. We can be disappointed with the results of Scott's tenure without tearing the man down.