The role of a godparent and/or confirmation sponsor is to help the child/adult live out a faithful live and attain heaven. They can be seen as spiritual guides, alongside parents, other family members, friends, and the faith community, that assist the child/adult in their journey of faith. It can become a beautiful relationship of living out the faith as a witness to those being baptized/confirmed.
There are a few guidelines the Church gives us to help discern who we should pick.