Is an assignment as a SHARP Officer a good choice?

It definitely won't hurt your career. It might be something that could make you sick to your stomach. I imagine that everything a victim advocate deals with is disgusting. Be it horrendous actions of perpetrators, having to tell people that their claims are unsubstantiated, these are things that can get to a person. Good luck with your possible assignment.

I have all the responses I need - thanks

Yes, it is a good way to diversify assignments and promotion potential.