I never found it to be very low noise, but old transistors like the 2n5088 that even called themselves "low noise" were not very... By the late 70s I was buying low noise bipolar devices with 1 dB NF to low Z (not 10kOhm).
Motchenbacher and Fitchen, a classic text about low noise design, wrote up the 2n4403 (another GP bipolar device) for low noise design, using several in parallel (last century). I am also aware of some low noise design in the 70s-80s using medium power bipolar transistors for their low Rbb, but they had to be screened for acceptable process noise.
I guess its all relative... The constant NF curves are useful design tools for setting current density but even with the 2n3904 dialed in for a MM phono cart you are still leaving a couple dB of noise on the table compared to using modern lower noise devices. I used a low noise JFET in my last phono preamp, also last century.
In a phono preamp application the 2n3904 could be acceptable to many due to the relatively high surface noise of vinyl, but there were still better options in my opinion and experience (I designed several phono preamps over the decades so melted a lot of solder in that pursuit).
JR