MacBook Pro won't read one particular CD (but CD player will)
it is possible that the CD has a scratch on it or is dirty. When this happens to me I wash it in the sink.

Warm water, and put a little dish soap on your hand (remove any rings!) and gently rub the CD back and forth (never round and round) until all the soap is gone. Dry with a soft towel (not paper towels) and try the CD again.

You could also examine the surface for scratches. If you find any, you could try the toothpaste method for buffing out the scratch (google it for details).

Failing that you may have to find a friend who can rip it for you. Some optical drives just have a problem with some CDs and DVDs. Sometimes I have to use another Mac or even an old PC to rip recalcitrant optical media.