In general, you use the singular with "many a":

> many a man came to try his luck.

The problem is that when you use *"many a"* you need to treat it as a collection of individual items, not as a group. You're treating "many a language" as a group in this sentence. You need to reword it something like:

> It's not worth learning many a language that you will never have the opportunity to use.