Does coffee, soda and all other carbonated drinks weakens the enamel of my teeth and if so should I have these drinks through moderation?

Absolutely. Any acidic drinks (all the ones you listed and more) can cause enamel micro damage and if done frequently enough can lead to huge problems. Moderation is a very good idea. Reduce frequency, reduce amount, and reduce duration (meaning don't take too long to finish your drink).