If your tap water is very, very hard, then it might be a good idea to use RO (or keep hardwater fish; there are some nice Lake Tanganykian cichlids that are very small), but for most tropical fish, you don't need to.
If you do use RO water, remember that it can't be used 'straight'; you need to 'remineralise' it, either by mixing it with tap water, or using a special mix from your fish shop; pure RO water is too pure for fish (and plants), they need some minerals in the water to survive.