In the last decade Belichick is the only defensive coach to win a Super Bowl. It’s the coach and quarterback. Your odds are better with an offensive coach. But if you can pair a defensive coach with a hall of fame quarterback, you have a chance.
Brady and Mahomes have won seven of the last ten Super Bowls, not a lot more to go around. One offensive SB coach has been fired twice since winning, and Manning won one with a defensive head coach.