So does this pipe actually carry contaminated coolant or is it just a scary picture?
It’s just a scary picture. Read the statement at the bottom of the article, it is part of the ocean water non-radioactive system. It is a temporary measure to redirect the small leak to a drain pending the repair. I’m sure there are real things to be concerned about at the plant but this is not one of them.
“...So does this pipe actually carry contaminated coolant or is it just a scary picture?...”
Just a scary picture. Circ water lines are just what was stated: cold ocean water in, warm ocean water out. All non-radioactive. If it were “radioactive hot”, they would have to declare at the very least an “Unusual Event” with the NRC...and maybe more.