And, the short answer is: NO! There is no way possible that 6 home football games a year will generate enough income for this stadium.
A few news stories I have read on it have indicated that the Facilities will be able to generate enough income to more than pay for the upkeep but not entirely pay for the initial price tag. I would imagine that should the facility become old enough that perhaps enough time will have passed and revenue generated that a significant portion of it's initial cost would be covered by the revenue generated.
Either way, it's a wealthy Texas community and they decided to spend the money on that to put their town on the map as opposed to the variety of silly things many communities waste their money on like a stupid dog park that my town is talking about.
It seems a little silly for us here to be pointing fingers at Texas in a wasteful spending manner. The truth is that state's economy is doing great, people are moving there and they have money to burn. Meanwhile in CT we're going to be looking at putting tolls on our highways because the idiots in Hartford can't seem to make due with one of the highest in the nation gas taxes and registration fees.