Best way to do this currently is to set up a basic blueprint system including “Get Precipitation strength at Position”.

Once you have your strength, you can scale your sound off of it. Keep in mind this will not check if it is rain or snow – just strength. You’d have to do that per sequence with get rain/snow for the interpolated keyframe.