The SOHC is prone to the timing chain rattle issue from 1997-2003. If it's not making noise now, it probably won't, and may have already had the revised parts installed. Other than that, these engines are pretty solid and will go a long time. 200K-300K miles isn't uncommon, though I have seen more OHV 4.0s beyond 300K (up to 600K).
I would be more concerned about the 5R55E it probably has. It's a good trans, but many are neglected. 1997 would be prime time for the 1-2 shift flare/missed shift that can occur due to a leak in the valve body gaskets. Again, if it's not doing it, no worries, but if RPM jumps on the 1-2 shift or it seems to miss second and hunt for 3rd, time for valve body gaskets or a reman valve body. Not a major repair, but if it's ignored I would imagine it would eventually damage the clutches.
I would also inspect the rocker panels for rust. It can hide behind the plastic rocker covers for years before becoming very noticeable.