I wouldn't go into it with the mindset "How bad is it?" That's just too gloomy for Disney!
I stayed there, I was going to go with Pop because of the buses but there were no more rooms for the deal I wanted when I reserved. Sure Sports is more boring looking than Music or Movies if you don't like sports, but I don't care about the decor if I'm only walking by it to/from the bus! It's nice being the first stop on and off, but most days we got our own bus and it didn't even stop by the other AS's so I'm not sure exactly how they work it. I suppose if you're there during a peak season that could be a perk, no watching overfull buses pass you or have them send out new buses to replace full ones, etc.
If I recall the two football buildings were nice and close to the main area. I didn't think it was all that big at all, but I'm a grad student who walks a mile+ to work/class each day so I know my standards of what makes a long walk is different than others.
I thought the room was plenty big. It's probably a Holiday Inn/Day's Inn size, but Disney so I think its a bit better maintained. Everything was brightly colored, not faded, clean, furniture was nice, etc. I had a funny reaction to the bath products so they didn't affect me much. We paid for the fridge which was a good convenience to have (we ate breakfast in the room) and even better because they forgot to get it to us until the 2nd day so we got it for free as an apology.
The sink area has a nice big mirror and plenty of counter space, and is separate from the toilet/shower/tub area so two people can get ready at once.
We were in parks from an hour or so after opening till closing every day so I just needed a place to lay down my head and shower and for $82 a night it was a steal. The only thing I would suggest is if noise bugs you, check Mousesavers and the ESPN sites and see if there are any big band/cheerleading competitions going on during your travel time. I think they tend to stay in Movies and Music first, then Sports, but it would be good to know if you should be expecting teenagers in advance. We had none, the entire resort was silent. I'd do it again easily.