Meaning of the word "agony aunt" in English

What does "agony aunt" mean in English? Explore the meaning, pronunciation, and specific usage of this word with Lingoland.