When the lockdowns started in early March, the stated goal was to "flatten the curve" so that medical and hospital resources would not be overwhelmed with a huge early spike in cases. That is a very different goal than the one which some people are now advocating, which is to absolutely minimize COVID-19 deaths and infections regardless of the economic cost.
The expert commentary which I have been reading, based on the curve-flattening goal, seems to be forming a consensus that a combination of testing and contact tracing, with some continued restrictions regarding social distancing and mask-wearing in public, would allow most of the economy to be re-opened without overwhelming the health care system. Certainly there would be more cases and more deaths than if the present near-total lockdown were maintained and complied with, but I think most reasonable people realize that such a severe lockdown cannot be sustained over a period of many months (let alone years until there is a vaccine).
As in many other cases (e.g., auto safety and even airline safety), there is a trade-off between dollars and deaths, and the solution is not to place 100% priority on minimizing deaths.
With respect to college sports, obviously the first step is frequent (weekly?) testing of all athletes, coaches, and managers. Anyone who tests positive would not be permitted to play or practice for at least 7 days or until they have a negative test (whichever is longer). All teammates would have to be considered as contacts (as if the whole team were a single household), so they could associate with each other but not with the rest of the campus community for 7 to 14 days, after which a negative test would emancipate them. So, even while they stayed on campus, they would have to do classes online during that time. If teams from other schools were following similar rules, then games could be played without materially increasing anyone's exposure.
Depending on the overall state of COVID in Connecticut and the degree of pressure on the health care system, fans might or might not be permitted at the games. If they were permitted, they would have to wear masks, and if possible occupy only every other seat. There would be no availability of refreshment stands if they required people to stand in line at close quarters. But some level of normal life should be possible (unless there is a huge "second wave" by October, in which case all bets would be off).
There has to be a middle path between total lockdown and total freedom which takes account, first and foremost, of health system capacity and readiness, and after that, of both medical and economic realities.