The OP asked, "Does anyone know how he (Stansbury) feels about the situation?"
I am sure he does not like the situation. He spoke internally (at the AA) of being "laser-focused" on fixing the football program and the results aren't there. Because Collins is his hire, he will have to keep a very low profile to maintain distance. My guess is that for the next 24 months, Todd will focus on fund-raising and building the new Edge.
Overall? I think Todd probably feels ok. The AI2020 was a big success, money is coming in from the ACCN, and the other sports are looking ok. My guess is that no one wanted to be the one to have to flip the roster. A lot of coaches won't even touch a program without talent ... that's why the rumor is that Lane Kiffin is going to jump to LSU ... he's losing 17 starters and his QB. So Todd is willing to live with Geoff struggling while new facilities are built, some costs get reduced, and we're in a better place in 2 years than today