In nature, in very small communities, sure. There can only be one alpha.
But human environments rarely ever work that way and we can rise above such basic thinking as well. We also shift roles and are more dynamic than animal communities. One can be in an alpha role in one environment and not at all in many others. Regardless, alpha roles are so rare because only one exists in each.
Would also be a false dichotomy to say alpha vs nerdy, as if they are opposites. The intellectually superior are alphas in many scenarios in human environments.