What version of Lightroom are you using? If you have Lightroom CC and are keeping up with Adobe updates then it will support the standard RAW files (Adobe does not yet support the dual-pixel RAW files but has announced their intent to do so).
However if you have an older version of Lightroom then your camera may not be supported. Typically when a new camera product is released, Adobe will add support for that camera in a RAW update ... but usually only for their currently shipping version of software (older versions of the program eventually stop getting updates).
I have a 5D IV and Lightroom CC and the RAW files are importing with no issues.
Incidentally, the camera name that looks like gibberish is normal. Once upon a time all camera used the same prefix on the file name. They stopped doing that several years ago and now use a name that starts with what appears to be a few random characters (but they are consistent so all the files start with that same prefix). This is helpful to photographers who own multiple bodies as it lets them determine *which* if they otherwise identical bodies took that particular image (for example, if you saw sensor dust on your images, you'd know which camera needed to be cleaned.). I've never bothered to change mine, but it occurs to me that the EOS Utility has an option to let you change the file naming convention.
12/05/2023: New firmware updates are available.
09/26/2023: New firmware updates are available.
08/18/2023: Canon EOS R5 C training series is released.
07/31/2023: New firmware updates are available.
05/18/2023: New firmware updates are available.
03/30/2023: New firmware updates are available.