That model year is still an inline six right?
If I were you, and I see you're confident enough to take it out, try cleaning it first (look at that gunk in the last pic), try cleaning the harness contacts, refit, test. Could save you a nice amount of money.
Maybe someone will correct me here, but I haven't heard of the TA harness degrading. It seems to by a pretty robust connection and I can't really imagine it getting damaged.
To me, your problem sounds more like a cam sensor problem, though that code is saying something else. Read around the 202 forums a bit, maybe you can use the saved money to buy something nice for your car later