Except it's almost universal that if your QB is shitty, your team is going nowhere. Can't really say that about a having a single shitty running back or defensive lineman or whatever. The QB is the cornerstone of the team.
Now baseball, however, that's a sport in which your analogy works.
Elon Musk isn’t a genius engineer that revolutionized anything. The brilliant minds at Tesla, women included did
This is partially correct. You are right when you say Elon didn't build Tesla all by himself. What he did though was have ambition and drive, and the money to seed fund it all. You can't argue that without Elon Musk, and his drive, and his money, all those brilliant engineers at Tesla and SpaceX wouldn't have built Tesla or SpaceX, they'd all have been working somewhere else.