"Agony Aunt" is chiefly a Brit expression, so I guess we can surmise how it's *supposed to be pronounced.

For further/previous discussion of regional pronunciations of "aunt", see another thread Wordwind started that also sort of warped off into insect kinship here recently in Q&A on Lifetime Pronunciation Addi(c[sic])tions.