I don't think it's uncommon to see Rottweilers herding, which was their original purpose.
I know of MANY dogs who are working in herding and who have herding titles, and there are quite a few Rottweiler herding Champions.
Long coated dogs do happen. They will happen much less frequently now that gene for long coat has been isolated and can be tested for. Long coats are undesireable in the Rottweiler. You may say or think what you will, but responsible breeders go by the breed standard. Long coats are a DQ in every breed standard globally. There is no way to tell if dogs in shelters are mixes or not, so that dog with a long coat and black and tan markings could come from a variety of ancestors and look like a Rottweiler.
No responsible breeder who cares about their breed would use any dogs for breeding who have disqualifying faults. If long coat puppies happen in a breeding, they should be required to be spayed or neutered, and placed in caring lifetime homes. And of course there is no reason why they can't work in obedience, herding, tracking, SchH, etc.