Rod's family outing comes after the star praised King Charles for speaking publicly about his cancer diagnosis last year