I have a quick and dirty solution if you are on macOS. Lightroom is utterly un automateable unless you invest the time to learn LAU. Problem is InDesign is AppleScript of JavaScript enabled. Getting the two to talk to each other is far more complicated a solution that it needs to be. Shame on Adobe for forcing users to develop 3 programming language skills to solve a simple problem.
Eliminating the need to dig around for link panels and such, you simply create a shortcut for “Reveal In Finder” command. Edit > Keyboard Shortcuts... > Product Area: Panel Menus > Links: Reveal in Finder
Now fire up KB and assign the following basic steps
Bring InDesign Forward
Type the Shortcut Key you assigned to "Reveal in Finder"
Bring Finder Forward
Copy the filename (the revealed file will be highlighted by default)
Type Command+W (closes the Finder window since you may be using the macro more than oce, so you want to keep things neat and tidy)
Bring forward the Lightroom window and brutishly have your software issue the following commands
Assign a Keyboard Shortcut to your new macro and you are done. Works 99% of the time and you don't have to touch JavaScript or LAU to get the "Reveal in Lightroom" function.