I am working on MacOS Ventura (brand-new update, November 9 2022) in the most up-to-date version of InDesign. Had the same problem on the latest Mac system as well.

My hyperlinks are trying to "link to destination" and won't open, even though I have unchecked "Shared Hyperlink Destination" and have "link to URL" selected. See screenshot for the popup shown by Acrobat when you try to click the link.

I have tried everything, no clue what to do. Please help.