A 9 year-old boy who has watched his sister suffer already for months surely understands that he made a horrible mistake.
I won't make a fuss about your idea of appropriate punishment, but assuming the boy needs to be severely punished to understand someone else's suffering may not be giving him proper credit.