This sound effect can be found on The Premiere Edition Volume 1, which was made by The Hollywood Edge. It is very similar to AUTO, HORN - CAR SPEEDING BY BLOWING HORN, a Series 1000 sound effect.
Links:
https://soundeffects.fandom.com/wiki/Hollywoodedge,_Doppler_Car_Horn_By_Ap_PE077401#Audio_Samples
Relive The Underground Story In Olympic City Between Eddie And The Eastsiders In Need For Speed Underground Remastered In 4K HD Experience The World Of Olympic City Featuring Returning Cars From The Original Game And New Cars Come In In The Remastered More Car Customization Character Customization Intense Police Chases And Street Racing To Relive Your Childhood Days Own The Night
