You need three things to get good low light sports pictures: a large image sensor, a bright lens, and a quick shutter. That pretty much rules out a compact or super zoom camera. You need a DSLR or perhaps a M4/3 style camera, and a lens with a larger aperture.
I'm looking for a camera that will take sports action shots at night, specifically football and still take great indoor sports shots as well. Right now I am alternating between a Kodak Easy Share Z650 for outdoor shots during the day because it has a decent recovery time and does a good job in bright light. Indoors and in dusk type lighting I am using my Kodak EasyShare Z1015IS. It is much better than the Z650 in the gym setting but at dusk it starts getting grainy and when it gets completely dark, even with the bright football lights, the players have to be within 10-15 feet of me to get a picture that is even semi-acceptable. I use the ISO setting and that helps at dusk.
Any advice would be appreciated.