I'd say @zroger73 is more knowledgeable about the Ridgeline than anyone on this forum, by a wide margin.Unfortunately, all that thread has proven to be good for is to promote fear mongering about the 6-speed!
Based on the information available, it appears the 6-speed is notably more problematic than the 9-speed.
He has also owned something like 3 Ridgelines with the 6-speed and has stated that he finds the 9-speed to be significantly better.
I owned a 6-speed Ridgeline for 1.5 years and about 11K miles. I'd still have it had it not been for the crazy used car values created by COVID. I cashed in my positive equity and got a 2021 model. After nearly 19K miles, I can say the 9-speed is hands down an unquestionably better overall experience.