If it was a wrist pin, could I drop the pan and pull that rod and piston and replace just that provided everything is in good shape?
I don't know specifically on this engine if you could pull from the bottom. MOST engines, the pistons with rings insert from the TOP (head off) due to accessibility.
I'm inclined to think it would be a pull it and rebuild it kind of thing, personally.
I'm just armchair quarterbacking this, though. Based on pulling the plug wire and the noise disappears, it COULD be the wrist pin OR the rod bearing. I'm thinking wrist pin because your oil pressure appears good AND a rod bearing typically has a squeal or a grinding noise associated with it.
You should do more diagnosis, including the following:
Compression test (rings and/or head gasket)
Coolant exhaust gases test (head gaskets)
Leakdown test (rings or valve seats)
Oil analysis through Blackstone Labs (or equal) (Determine type of metal in the oil will identify failing parts (aluminum=piston, steel=rings, copper=bearings))
Pull all your plugs and post a picture of them, in order 1-6 and they should all be uniform in color. If one or two are different colors, that may show more signs of actual failure as well.