Democrat Guilford County District Judge finally resigns amid misconduct charges