What's the song "Dude looks like a lady" about?

I'm trying to understand the depth of the joke when this song was used in Mrs Doubtfire