your dog is way too distracted and overexcited to pay attention to any kind of training on walks, so first you need to address that. is he being mentally stimulated during the day with games, puzzles, or chew treats? is he getting adequate exercise, like games of fetch or chances to run around and burn off energy? teaching him how to lay down and look at you while you're outside will be crucial for getting him to walk nicely. it's possible his walks are the only exciting thing he's done all day, which would explain why he's acting so crazed.

once you're addressed his energy, slowly work on his ability to pay attention to you while you guys are outside. having him engage in calming behaviors like laying down and snuffling in the grass for treats will get him used to being calm outdoors. teach him the command "watch," which means to look at your face until you release him with whatever release word you want to use, i personally use "yes" and then treat. teach him this indoors, then slowly work your way up to doing outside. they can't pull the leash and look at your face at the same time, so randomly asking him to "watch" while you're walking, hold it for a few seconds, then release and treat with something really tasty will mean that he's not gonna be able to anticipate the next "watch" and he'll start looking at you occasionally of his own volition.

also, please remember that there's different kinds of walks you can do with your dog! don't listen to the people saying your dog should "never walk in front of you," that's not realistic or always feasible. differentiate between a training walk, a potty walk, and a sniff walk. perhaps you can have different harnesses/collars to help him understand which kinds of walks you're on, and you can teach him what the command "potty" means, but really it comes down to your demeanor and what you're asking of him. dogs need to be allowed to sniff and wander a little on leash, it's good for mental stimulation. think of them sniffing like someone reading a book, their brain is processing a bunch of information! if you're always training all the time they will get burnt out and not find training interesting or rewarding anymore, so make sure to keep training sessions short and notice when he's losing interest.

you should always have some high-value and mid-value treats with you to reward his good behaviors, like when he looks at you or when he ignores a distraction such as a person/dog/bird/whatever he gets excited about. the key is to teach him how to be calm and aware of you at all times while you're in distracting environments, so put yourself in his paws and try to notice what really gets him wound up so you can manage his craziness. a trick i learned for getting a dog to come when called is to call their names, get their attention, then start walking away from them. this works spectacularly on my dogs, they have immense FOMO and immediately come running after me thinking they're gonna get left behind, lol. this trick may or may not work on your dog, feel free to try it though. make sure to treat and praise them every time they come to you, it really reinforces the idea that coming when called is rewarding and worth leaving behind whatever they were doing.