RO water is best in all aspects, FO, FOWLR, and Reef, it takes out both good and bad, but nearly all saltmixes contain all the needed good stuff at a good amount, and the salt mix does not contain bad stuff. So no matter what RO water would be better.
Now if you only want an FO or FOWLR tank, you dont have to get RO water, but be prepared for algae out breaks, and one day, you will be tempted for a coral.... So you are going to make a switch one day.... IMO it is always best to use RO water from the start.
And what if your tap water contains high amounts of copper or other deadly things to invertebrate, then you cant keep a CUC which means even more algae, you cant keep decorative shrimp which, well, i wouldnt like, and other invertebrate in your tank may be effected.