Second half of this video might be relevant:
Source: https://youtu.be/WiHk9hMpLIA?t=120
Target's ship and loadout in SC gave away their intent. At a bit after two-minutes in, an unresolved contact (silent running doesn't change the maximum range for unresolved contacts, just resolved ones) away from the group revealed rough location, then the sillouette when target was against the sun confirmed it as the DBX I was looking for. A hitscan rail shot let the target know there wasn't any sense in trying to hide. The target flashes white and resolves automatically during the torpedo lock it tries to make, which gives me an opportunity to order the SLF to attack it, providing a very obvious indicator of specific location. A moment later, while still too cold for me to lock on to, my fire-at-will turrets begin to track and engage it and I follow up with some more fixed hitscan fire. Realizing the jig is up the target withdraws.
Obviously, things can get much more complex and confusing with multiple targets and more sensor clutter, but I find this example useful to isolate how several related mechanisms can work.
Long range sensors would have significantly extended the range at which both the unresolved target would have appeared, as well as the resolve distance, but as the former is already beyond weapon range and the latter still very short, they are rarely a game changer when it comes to stealth. Nightvision (which that video predates) is a much bigger deal., but even it is now limited to sub-10km and will rarely reveal things beyond basic unresolved detection radius.