God Parent

Hello. My husband got asked by his sister if he would be the godparent to their new baby. I never had godparents, I don't know anything about them. Is it common to just ask one and not their spouse? What even is the role of a godparent?