If by super power you mean something akin to U.S of 1990's and early 2000's...then no, even China might never be able to achieve that. World is moving towards having multiple poles of power.
So in this context, can Turkey become a great power of the world? Very possibly so.
Turkey has all the right ingredients to become one of world's great power. It is situated at a very geostrategic location, it controls a vast landmass (bigger than UK+France combined), it has a large population, it is an industrialized country with very advance technological base, and it is already a high-income country ($20,000+ per capita in purchasing power). And most importantly, Turkey also possess a very powerful military that is large numerically and possesses modern weapon systems. Moreover, Turkey also posses multibillion dollar defence industry locally and produces a lot of top-notch defence systems in home.
So, as a medium power, Turkey is far ahead of states like india or Pakistan for that matter in terms of technological base, living standards, defence industry, and so on. If Turkey was a nuclear power similar to India or Pakistan--It'd be a minor 'great power' already. However, Turkey is not a nuclear power...and this significantly exposes Turkey's national power when it comes to the league of big powers of the world.
So in order to be a great power, Turkey will need to significantly expand its economy and especially military. Turkish military is not a professional military. Turkey will have to streamline the readiness of it's military and increases it's effectivness. Moreover, Turkey needs to expand its economic output much faster than Europe and catch upto France atleast in various sectors related to aviation, defence industry, high-tech products, shipping etc. This can take several decades.
So can Turkey be a great power? Most certainly. But it will be one heck of a task for Turkish nation to accomplish.
On a side note: Turkey's advantage over others in OECD (bar few) lies in its demographics (among other things). Erdogan keeps on to say "have 3 kids, have 3 kids"....he isn't randomly just saying it. Turkey needs to have positive demographics for atleast 3 more decades or so. It is absolutely necessary to push Turkey from a medium-high income country to high-high income country like Germany, United States, and Israel etc.
So Turks should not overlook the importance of demographics when it comes to their national journey towards being a major world power of 21st century.