I can't speak for freshwater jigs, but I use super glue on jigs for striped bass, and they don't seem to care.
Of course there is a difference of seasons and water temps between the two, but it should work fine.
I would advise that you use any glue you choose VERY SPARINGLY, as too much can create a stiff crust that could affect the jigs movement.