I did not see the Bible talk about an afterlife for pets,
"Test all things; hold fast what is good." (1 Thessalonians 5:21)
So, I am offering ideas I have gotten by thinking about things in the Bible and by observing people and their pets.
And you can see if I offer anything that helps you.
In the Bible there is talk about the lion lying down with the lamb. So, to me this can mean there will be animals.
but I find believing there is one, and that Christians will one day be reunited with their pets where the pet can also live for eternity to be very comforting.
But I am concerned about how people can possibly be able to so love their pets but they are not into loving any and all people like Jesus wants. Also, a pet dog can be very loving of one person who is giving the creature what he or she needs and wants. So both the owner and animal can be mainly about getting their own way.
We need to get into family sharing and caring with other children of God.
So - - in case you are having your most comforting relationship with your pet . . . I think we need to pray for you to grow in the good which comes with sharing with various Christians. And know that even if you do discover problem people, God's love keeps us from getting hurt and suffering, plus we can be good examples to help those who turn out not to be genuinely loving oeople > God's love has us ready for sharing with really caring persons, and ready to help anyone who is wrong.
Or could it be that after any animal dies that's the end of their life, and the animal doesn't even remember anything or has any consciousness at all after dying.
Well . . . there will be the day of judgment. And I would say Jesus will evaluate how we have related with our animals. And they could be present for the feedback we get then.
And if animals could be in eternity with us, possibly they will somehow be judged. Our doggie is so cute and charming and so delights lonely people. However, he seems very much about himself. And for worldly women who so love him, loving him is no substitute for how Jesus wants us to love any and all people.
"if you love those who love you, what reward have you?" (Matthew 5:46)
An animal can be part of God consoling a person. But God's love does us the best good, including while we share as family, and while we reach to people who are lost and do not know God in His all-loving and compassionate and generously forgiving love.
This love makes us strong so we can't be hurt and made to keep suffering. Because God's love is almighty in His own safety > I see how Peter experienced this so he could write 1 Peter 3:13 >
"And who is he who will harm you if you become followers of
what is good?" (1 Peter 3:13)
So, the best comfort is in God's love and also makes us able to comfort others. Take a look at 2 Corinthians 1:3-4.