I don't really see many people in Charlotte that have a strong allegiance to anyone for football.
Tensor do you think Charlotteans in mass will give up their allegiances to UNC and other schools and support "Charlotte's team"?
With so many transplants in the area, I think there is plenty of opportunity to draw in the average fan if the team is successful.
For basketball, it is less likely. Charlotte had a lot of success in the past, but the casual basketball fan in the city really only got excited when Cinci/Louisville came to town. Winning will take attendance back to 7500+/average, but I don't see CUSA opponents filling up Halton unless we end up running that conference the way Memphis did (which I don't think is likely).
A successful football program will help interest in all sports though.