Roon has an export feature for music files. This will also work for Roon-OS ripped CDs in the known way … select an album (or tracks) and (basic) metadata will get written to these files as tags. So if one needs ripped files outside of Roon it should work reasonably well.
I couldn’t really verify how automated identification works because the discs I’ve tried it with I had to identify manually. But yes, as long as the files are staying in the ripped folder, metadata will only reside in the database.