I wouldn't worry about it too much for 3 reasons: First, Honda knows about the problem, has presumably been taking steps to fix it.
Secondly, even based on the past occurances of the problem, your probable liability isn't that much. They have to fix it when you're under warranty, and they'll probably fix it for free if the vehicle is less than 8 years old, per their class action agreement related to this problem. So up to year 8, your liablilty is 0, other than perhaps living with shaking for a little while.
If you're looking to keep the vehicle 10 years, what are the odds of the problem cropping up in years 8-10? Based even on older Pilots, it's not that high. Certainly not more than 10% for that narrow range of years. So if an engine replacement for an 8-10 year old Pilot costs $4k, and you have a 10% chance of it happening, that's a $400 consideration. And it's 8-10 years out, so if your investments double in value every 8-10 years, your present value cost to factor in your decision making is $200, which is dwarfed by the purchase price of the vehicle. Of course I'm using rough numbers here, but you get the gist.
Thirdly, the gas milage the VCM will save you from years 1-10 will just about pay for an engine replacement in years 8-10 should you need it. If VCM saves you 4mpg (18mpg-22mpg) and you drive 130k miles on $3/gallon gas, you've saved about $4k in gas.