The local repair shop says Midnight (my car) needs a new transmission. :( Only 7.5 years old and 104,000-ish miles. Said second gear, as in the physical gear, is broke.
Going for a 2nd opinion at the Honda dealership tomorrow morning. The parts guys said needing a new transmission is rare, there are a lot of solenoids that could be the problem instead.