One of my previous DD vehicles was an '06 Trailblazer SS with the 6.0 LS2. I had 1-7/8" Kooks stainless steel long tube headers and Kooks stainless steel catted Y-Pipe. Both the headers and Y-Pipe were just left bare stainless, no ceramic coating. I live in Ohio where we get snow and road salt, I drove quite bit for work all through the mid-west year round and after 98K miles the headers and Y-pipe were still in great shape; They were dull and discolored due to heat etc. and didn't look the greatest, but they weren't rusty, and I never had any exhaust leaks.
If you're considering doing the ceramic coating it's definitely something you do to the headers while they're new before you install them, it's not something you would want to do some time later.
Try reaching out to some local powder coaters to see if it's something they offer, might be able to find a lower price locally than the Jet-Hot $390 adder? Or don't get it done; Getting your long tube headers ceramic coated is not a requirement.