S - R = infinite, Good, no shield short
S - G = infinite, Good, no shield short
S - W = infinite, Good, no shield short
S - B = zero, Hmmm, this should be infinite
R - G = infinite, if R - G is a coil, it is open (bad)
G - W = infinite, if W - G is a coil, it is open (bad), if it is a wire from each coil, it is a good thing (not shorted)
R - W = infinite, if R - W is a coil, it is open (bad)
R - G and R - W pretty much covers the coil with the red wire. It is open and hence is bad. G - W from your drawing appears to be a wire from each coil, and a reading of infinite is good (when they're not joined).
Where is R - B?
Per your drawing;
R - G is a coil, it measures open and is bad.
W - B is a coil. Since S - B read zero and S - W read infinite, it measures open and is bad.
This does not look good to me.
For these to be open, either the pickup cable was pulled on and wires in the pickup were broken, or enough current was caused to flow through the coil to burn out the wires like a fuse.
AWG, I actually DO fill my head with this stuff since knowing the models is key. Many years ago, stranded in a desolate place, finding a spool of 16 gauge hookup wire and an Edison screw-in house fuse base (and a house fuse), I was able to effect electrical repairs to a car's cooling system (fusible link as well), and escape. There was no cellular connectivity, heck they'd just been invented. There wasn't a telephone either.
Rule of thumb (well, logarithms). A 12 gauge wire is good for 20 amps. Each 10 gauges indicates a reduction of a factor of 10 in current carrying capability. From 12 gauge to 42 gauge is 30 gauges or 10
^3 in current reduction. 20 / 1,000 =20 mA.
If each coil was 5,000 Ohms, one would have to develop 100 Volts across each coil to cause this current to flow. However, since most wire turns are not open to the air, less current might cause damage. After all, 100 volts and 20 mA is 2 watts, and after a while, damage could well happen.
Either the pickup cable was pulled on or high voltage was presented to the jack, either in the form of an amp failure or a significant energy voltage transient.
Was it connected to a home-made amp?