MPlayer supports streaming quite well and I use it very often. Check the "Open stream" menu or simply run "mplayer <your url>" from a shell.

The lack of HTTPS support is a problem, though. Frank is working on it...