It may seem like you need to subscribe to Apple Music to use the Music app on your Mac. But you can simply ignore Apple Music in the sidebar and search results and use it with your own purchased or ripped songs. You can also disable it so it doesn't appear at all. And yes, you can still rip songs from a CD if you have an optical drive.