The Ridgeline used the 6-speed transmission for 42 months from June 2016 to December 2019. There have been 71 reports of transmission failures and at least that many reports of failed torque converters and not including other issues such as overheating and judder on this forum.
The Ridgeline has used the 9-speed transmission also for 42 months from December 2019 to now. There have been 4 reports of transmission failures on this forum.
There have been about 590,000 Ridgelines sold.
There are about 80,300 members on this forum. If all members were active and valid Ridgeline owners, that would be 13.6%.
Assuming 142 transmission and torque converter failures is actually is actually 1,044 including those that we don't know about because they weren't reported on here, that's about a 0.8% failure rate. Of course, nowhere near all of those 80,300 members are active and valid Ridgeline owners. If it's half, the failure rate becomes 1.6%. If it's a quarter, the failure rate becomes 3.2%. The actual number of valid and active members is almost certainly less than a quarter which suggests that the failure rate is higher than 3.2%. 20 years ago, Honda extended the warranty on automatic transmissions when the failure rate reached 2%.
No matter how you cut it, it seems pretty obvious that the 6-speed transmission is far more likely to fail or the 9-speed is far less likely to fail.
This is the best data we have available. Only Honda knows the actual numbers and they haven't shared those and are highly unlikely to do so unless a recall is issued and the information becomes public. Since these failures have not presented a significant safety risk, a recall is highly unlikely.
I don't suffer confirmation bias, either. I am not a Honda or Ridgeline owner at the present time. I do not and have never worked for any automaker or dealership. I simply gather and report data as a personal and sometimes philanthropic hobby. I carefully monitor this forum for every report of a transmission failure and add them to running lists.