Normally Closed Negative Output, Positive Input Relay
The issue was not with the wiring flow, but instead that the current coming from the transmission was only a measly 5mA (@12v), which isn't enough to trigger the coil inside of the relay. This makes sense since that wire goes directly into the ECU.