This has always been a little tricky in my experience. I think it’s because of some Apple permissions logistics.
Usually, if you start with the CD ejected, and then open the CD Import dialogue box, it will then let you see the optical drive. Then it should be safe to insert the CD and it will appear as an option to import it.
Sometimes you have to play around with it a bit.