On macOS: /Users/[YourUsername]/Library/Application Support/Adobe/CameraRaw/Settings
How to Import and Use Your Converted XMP Profiles in Lightroom
Lightroom sometimes fails to index XMP files if they are placed in the wrong folder manually or if the internal metadata structure of the XMP is corrupt.