There are diffrent kinds of freshwater fish. Some perfer a soft water while others prefer a hard water. Softwater fishfish include neons, kribs, apistogrammas, Discus. While hard water fish include Tanganikans and African Chilids and others. Soft water with a PH lower than 7 and hard water with a PH above 7. Then throw in ALK. There are additives that you can add to reach the desired water conditions you are trying to mimick.
So yes you can use straight RO or DI water if you are adding additives. I would not use straight RO or DI water.