So, I'm assuming you are having 1 of 3 problems:
1. You are trying to copy files directly off of the camera via a USB cable. Canon does not support USB Mass Storage Mode. To copy directly from the camera you will need to use Canon EOS Utility to first transfer the files to your computer, and then you can import them in to Lightroom.
2. The other problem is that due to the way that most CFExpress cards are mounted, Lightroom does not work like it does for SD cards. CFExpress readers end up getting mounted as an SSD, and in Lightroom when you click on the root of the drive it shows nothing. If you expand it, and click on DCIM, it will also show nothing. BUT if you then click up above on the checkbox that says "Include subfolders" then it should work.
3. You are using an old version of Lightroom Classic that does not include support for the Canon R5 files. In this case, you will need to import the files using Adobe's DNG converter, generating files that your software supports.