I believe all animals (not including humans!) cease to exist after death. It's not "them" rotting, just the body. They don't go to heaven, or to hell. They're just gone.
I do also believe that heaven is absolutely perfect, and that if animals have to be in heaven to make people happy, they'll be there.