From what I have read, Honda sourced the ZF 9 speed directly from them. Chrysler made them in-house under an agreement with ZF. I think Honda did not have enough capacity for manufacturing their new 10 speed, so they went to ZF to supply them with transmissions. It is why you see some models available with both the ZF 9-speed and Honda's 10-speed.
Lots of issues with the Honda 6-speed, especially on the 2016+ Pilot and Ridgeline. Family friend of ours had their transmission pack it in on their 2018 Ridgeline with only 80k. The ZF should be solid once the updates are done to it and it is maintained to schedule. The fluid changes are expensive though because of the cost of the fluid.