Do you know whether Honda even makes Odyssey with a manual transmission? It seems everything is an automatic nowadays.
I don't believe they do. I haven't tracked their transmission faults the last couple of years. I used to have an Acura (Honda) MDX. I got rid of it after two years because the transmission fluid was 'browning' indicating excessive heat.
Just do your research. There are internet forums for just about every vehicle that owners can have discussions.
Good luck!