Live or recorded?
Live, many rooms / mixes are muddy enough that a J with both PUs on simply gets buried creating little more than an low frequency event. A P might be heard as notes from an instruments, maybe. A Stingray can produce the missing mids to allow it to be heard as a instrument playing notes, not just making low sounds. So live, a Stingray can sound like the P-bass in your head.
In the studio, things are very different.
Different tools for different tasks.
Live, many rooms / mixes are muddy enough that a J with both PUs on simply gets buried creating little more than an low frequency event. A P might be heard as notes from an instruments, maybe. A Stingray can produce the missing mids to allow it to be heard as a instrument playing notes, not just making low sounds. So live, a Stingray can sound like the P-bass in your head.
In the studio, things are very different.
Different tools for different tasks.