I have bought the pilot two months back and I have added ~2300 miles so far. Overall, the ride is comfortable with minimal road noise. It can handle snow quite comfortably even on a 2WD. I initially experienced the truck pulling to right and took it to the dealer. He told me that he observed the problem too and rotated the tires and adjusted the tire pressure! I don't have a lot of complaints about this now. My biggest complaint is the mileage. I am averaging 16 in city and maybe 21 on the highway which is far less compared with other SUV's in its class for a 2WD. Overall nothing out of the box, average SUV for 30K.
Fuel Economy; My 16yrs old accord gives far better mileage. Its a shame that Honda technology has not developed a lot during these years.