It's part of Mac OS X's UNIX heritage. X11 is the universal windowing system for UNIX OS's (e.g. Linux, BSD, Solaris, etc.). It's very powerful, a bit abstruse, and a bit less pretty than Aqua.
Most people who don't have a UNIX background probably won't ever need to use it. ...