In defense of FM transmitters for the OP and others: FWIW, I drive a 2004 allroad that has very nice audio equipment, but no built in bluetooth, nor an aux input. I have resisted modifying the audio and had an FM Bluetooth transmitter installed seven or eight years ago that has worked beautifully, initially with a Windows phone and -since T-Mobile forced me in May 2022, 2 or 3 android phones. Previously I also had the same unit installed in an A6. They've all connected fine upon ignition and very reliably to take and make calls and listen to my thousand-or-so SD-card stored albums. With Android Auto installed or connected somehow, my phone also launches a music app automatically upon ignition. (It doesn't do anything else that I can tell -or require.) My Windows phones used to play and send texts as well! It's not absolutely flawless, but nearly so: maybe 1% of the time, the phone doesn't connect automatically and immediately, and I have to wait a minute or so, or restart the engine and/or phone. Not as reliable as most electronics, but plenty good enough for my car audio needs!
The device is a Tranzit Blu by iSimple which I believe, sadly, is no longer available. Fortunately, the audio shop that installed it is still going strong and tells me of each generation of available options.
Good luck with the Honda and I'd still insist on or expect Bluetooth to work.
I have a HiBy DAP that I've never tried to connect to my car audio, but that's not an android device anyway and thus impertinent to this thread.