I think a lot of us became basketball fans well before the football program upgraded to FBS, which probably skews the results some. Also skewing the results is the fact that the football program's never really been competitive outside of maybe a four year stretch under Edsall. It would have been really interesting to see what the football fanbase could've been had it continued on that path, but unfortunately nine years in the Big East was not enough to make the program desirable to the power leagues.
I've never really followed women's basketball, but I'd imagine it's tough to be a die-hard fan of both with their seasons taking place concurrently. Same with hockey (which UConn is even newer to than football).
Sadly, I think the sustained basketball success has created the perception that we failed to build a representative football fanbase, when in reality we were undercut mid-stride. I can't tell you football definitely would have assembled a huge fanbase in that time (~2013-2024), but I can't tell you it failed, because it didn't. The sport failed the program. (If you want to see a program that has failed to achieve a following consistent with its opportunity, head to Chestnut Hill).