Fundamental difference is quality of output water.
The long-term use of water treated by RO for irrigation leads to gradual soil degradation due to the irreplaceable proportion of salt in irrigation water.
This can be illustrated by the case of Israel, where irreversible soil degradation has occurred in many places due to usage of low-salt irrigation water from Reverse Osmosis.