Help

Hey guys! I’m going through a difficult time. I have my 2 year old staffy who I’ve had since a puppy. I’ve tried everything to help with his aggression. He doesn’t like any dogs, cats, birds, squirrels, babies/ young kids. He’ll tunnel vision and won’t listen to any commands. It’s almost as he forgets where right there with him and his main goal is his trigger. Today we went out and tried to introduce to a puppy and he went crazy trying to bite it pushing it down with his paw.( we purposely put a muzzle on so if he did try to bite it wouldn’t happen). My partner and I are the only ones that can walk him. I’m undergoing a surgery soon and want to have kids in the future but I’m not sure if that’s possible. I’m sitting here typing this debating if I should keep trying or surrender him. I’m beyond scared of how he acts with animals and children. My family is saying to surrender him as I’m playing a real risky game and it’s only a matter of time until something goes wrong. I’d like to hear everyone’s opinion, tips, stories on what helped you. Would in home trainer be better, onboarding(we saw one that he would stay there for 2 weeks), one where he’s there all day gets picked up in the afternoon, or a hybrid. Thanks in advance.

I’d like to note that I have a 6 year old sister that he once got along with and now he can’t see her without him losing it. He saw her a while ago off leash and absolutely lost it. He tried to lunge onto her not in a “I’m excited to see you” way he stiffened pupils dilated and tried to lunge at her. He started shaking and barking at her. He’s seen her since but in his crate and we get the same reaction.

EDIT I have taken him to get a consult with a trainer they said the aggression and prey drive would never leave just be a bit more manageable but we would never be able to trust him around any of his triggers.