Well, I got the light out successfully, but it ended up being a bit of a chore
I found a good deal on 4 new OEM Honda (the TRW make) sensors with the correct part number etc. So I bought all 4, thinking I'd just have 4 installed so I don't have to chase down single failing batteries one at a time next few years.
This was my first questionable mistake
Went to the tire shop and they scanned my existing ones. 1 was bad/didn't respond. Ok, good, so it's not the TPMS module that is broken. Of course the tire guy suggests that I replace all 4. Since I have the sensors I agree. $16 per tire for their labor. Let's go.
They get them all switched out. Then they go to program them. Something is odd with the interaction between their scanner and the new sensors. Except ONE of the sensors seems to work fine as a "2008-2010 Odyssey" sensor yet the other 3 come back as "2011-2015". I dunno. I have a feeling they were doing something wrong with the scanner but at this point I was knee deep in 1.5 hours of total time and I'd already paid 64 bucks for labor. So they decide to reinstall the original 3 OEM ones that were working, and use the 1 new that they were scanning up. In the end, they got it all back together and put the TPMS in learning mode, and after driving around a bit after I left it went off. Great!
But now I need to try to return 3 of 4 sensors that scan positively yet somehow didn't link up as the correct unit in their tool. All 4 that I received were identical makes and part numbers. I am still dubious as to how 1 worked but the others wouldn't.
Whatever, I have my light out now, for total investment of 80 bucks. Unfortunately, I have 1 new and 3 existing sensors, still. Hopefully the existings will last awhile longer. They say that they have some mileage-based drain (they broadcast while the car is driving but sleep otherwise) so maybe I'll be lucky since I only have 50K miles.
FOR THOSE FOLLOWING MY PATH.....I'd suggest it may be easier to just buy 1 sensor at the store where you're having it done and let them install it. It will be 60 bucks total and you'll know that you'll get a working sensor because they use a bunch of universal cloneable ones. Also, there isn't really any economies of scale to getting all 4 replaced at once. So while it would suck to go spend 1.5 hours 4 different times over a few years, unless you really know that all of yours are going to fail in short order, you don't get any $$ discount for doing all of them at once. That said, if you go one by one, then you are sort of stuck doing that because it is hard to know which of the 2 are "new" and which are "old" if you later decide to replace a few at a time. To this end, I'm going to try to mark the new one right now with a sharpie or something so maybe I can keep track through the future three-card monty of tire rotations!
I spoke with the Honda dealer first and asked whether they were covered by HondaCare. THEY ARE! Yay! But only depending on "how" they failed. So if they are "damaged" then they aren't covered. And I would have to sign up to cover their stupid $125 or $150 "diagnostic fee" which would only be covered by HondaCare if the TPMS sensor is. So I decided it felt like too much of a slot machine pull to do it through the dealer. If you don't win their lottery of "how did the sensor fail" then you're in for an expensive part, plus expensive labor. In reality, the failed part looks undamaged so I should have gotten it for free from HondaCare but again, too much risk....