i have a 99 CRV and have always hated how long the automatic trans stays at a high rpm longer than i would like before downshifting; i attribute this as partly to blame for my less-than-hoped for mileage. tried using regular dexron 3 instead of honda official fluid, didn’t seem to make much difference. yours sounds extreme enough to be a definite malfunction rather than just a slow downshift as designed into the tranny. good luck, sorry i don’t have any advice other than adding my whine to the forum.