I've always seen him as the "comic relief" character of the film. It's a dark movie in places and sad at times; Thumper is there to cheer us up and break up the tension a bit.
He made me smile when I was a kid and has been my favourite character ever since!