Sounds like you already decided and just need to have the courage to follow through. (Hint: someone will get hurt that life. Be direct and decent about it as much as you can) (Hint2: No matter what the kids feel, their father will always be their father, don't try to come on in the middle of that.)

is this something you acted on already? did your husband cheat or is abusive? or are you a grass is greener on the other side type? if it’s the latter you should probably look inward and fix yourself first

it really depends on context why do your kids hate there dad

You should probably go talk to a councillor to get your head sorted about yourself and your marriage BEFORE making any decisions you can't unmake.

you see the resource officer in a professional capacity. you have no idea who he is behind closed doors. if you're going to leave your husband, leave him for your own happiness. don't leave him for someone you literally don't know. he might not even have you, he could lose his job for dating you

Don't leave your husband unless he is abusive. Again unless he is abusive it is you with the problem.