Pardon me for being thick, but what does it actually mean to speak in tongues?

Technically, it means to speak in a language that you're not familiar with. In religious situations, it's the Holy Ghost speaking through you in a language you don't understand, usually to break down a language barrier between people.