First I was going to say this: I have a friend who shoots sports and uses Photo Mechanic software to select photos for editing. It takes in and shows in-camera ratings.
Then, I figured out how to do it in Lightroom, with help from the Google.
First, find out which card your camera is set to use for playback if you save to two cards. This is important because the star ratings are only written to the card that the file that you are viewing on the back of your camera came from.
In my Canon cameras it is the first setting in the wrench menus. You can specify which card to playback from.
Import your photos from that card into Lightroom. Select them all in the Library module and then, from the Metadata menu select "Read Metadata from Files". Your star ratings will now show, or at leas mine did.
This worked from both my R6 and 5DIV.