Catholic Cardinal George Pell's appeal against his child sexual abuse conviction has been dismissed and he will remain in prison.