Before you get to carried away with the circuit you need to define the problem you want it to solve. It sounds to me what you really want is something close to a constant signal (whatever you are playing on the stereo) to noise (be it wind induced, tyre roar or a noisy passenger

). There are relatively sophisticated ways (x-correlating a feed from the stereo with one from a mic that hears noise and subtracting out to get a measure of "just noise") and unsophisticated ones (stick the mic somewhere noisy away from speakers and hope it measures "just noise"). You can also decide if you want to measure "noise" directly or measure "noise factors" such as vehicle speed. Anyway, whatever you do you will almost certainly find it cheaper and simpler to run an amp and put your circuit between the head unit and amp (the circuit can then be all electronic - no horrible electromechanical attenuator). The "guts" of such a solution is a fairly generic DSP platform (potentially something off-the-shelf) that has at least 3 analog in (assuming stereo signal you want and 1 mic for measuring noise) and 2 analog out (audio to the amp). Of course, given such a setup, its just an algorithm issue how fancy you get - you could start not just adjusting volume, but actively canceling noise (another high-end feature).... Its a fun project if you have the time and the skills (or the desire to acquire them) but don't start it if the result is the destination and getting it right (the journey) is something to endure....
Personally, I'd just turn down the noise (stereo) and listen to the signal (engine), and enjoy the modulation via right foot....
__________________
Darryl
'81 Autodelta Turbo Alfetta (perpetual project)
'91 75 Twinspark (not so daily driver)
'88 Jaguar XJ40 Sovereign (the wifes car/she that must be maintained)
Cannondale road bike (daily peddler)
Colnago road bike - old, Italian, steel, and no rust