By definition , most people must be average programmers. everyone cannot be 'extraordinary'. I am pretty sure that you're probably average too unless you're better than 99% of the programmers.
Nothing wrong with being average programmer, everyone starts somewhere, and my early Stack Overflow questions are hilarious.
Also, it's perfectly fine to aim at being average - one may be aware of various limitations (health, intelligence, memory, ADHD and similar disorders, family situation) that will likely limit them to being average at best. If they aim for being a star despite those limitations, they risk burning out and getting nowhere.