What does sweet of honor mean?

Ah, honey, it's "maid of honor," not "sweet of honor." The maid of honor is like the bride's right-hand woman at a wedding, helping with planning, keeping the bride sane, and maybe even holding her dress while she pees. So, if you're ever asked to be one, just remember to bring your A-game and a flask of emergency champagne.