We are second owner on an '03 Pilot. The only trans problem was a 4th gear sensor (located outside) that warranty fixed. As a Honda tech for 23 years, I've put dozens of trannys in the Odyssey, but not the Pilot. It's got about 120k on it now. No other issues.
Mileage runs 17 to 22. There's a lot of room inside compared to the overall size of the vehicle.
The 4WD system is not for serious four wheeling. Just drive it.
The "fly by wire" throttle body came in '06. I prefer the cable throttle type.
Just be sure the one you find has had proper maintenance. T belt, spk plugs, valve adjust all due at 105k. ($$$$)
For those that fight for it, freedom has a flavor the protected will never know.