RO water is reverse osmosis and gets lots of the chemicals out of the water (chloromine/chlorine). It is good to drink. It gets most bad stuff out. However, DI is deionized. That means when you filter through a DI resin, out comes pure H2O. Not good to drink as drinking water needs some of the additives and sediment. DI is what most reef keepers use because then they are starting with straight H2O rather than water that still has trace elements or chemicals included.
For instance, RO water will still give you a TDS (total dissolved solid) reading anywhere from guessing: 30 - 120 depending on your system and environment. However, DI water will give you a TDS reading of 0.
Now, I think that is all pretty accurate to my understanding. Hopefully a water guru can get on and clear up anything I goofed on.