It works best when images are clear and the main item in that image is easy to understand/clearly defined. At times the machine learning system won’t recognize the image.
The feature is simple to use but isn’t always available. I have not tested if it takes you to Apple Music when you photograph a CD cover How to use Visual Look Up