The paint I used might have been that Kylon. It doesn't chip for me. I run string trimmers near it, sun, rain, snow ice no problem. I think you would have to work at it to beat it up, especially in an aquarium application. It has good adhesion. Unless you're taking things apart all the time.
But it's good to know about the black product. I'd definitely use that in a new build. I was assuming the OP wanted to paint pipe already in place.