Of course, he is not literally sitting at the right hand of the Father, as the Father is also God and Jesus tells us that God is spirit, and a spirit does not have a body on which to have a right hand. The passage is metaphorical.
I believe that you are mistaken. From the
Catechism of the Catholic Church.
**
659 **“So then the Lord Jesus, after he had spoken to them, was taken up into heaven, and sat down at the right hand of God.” Christ’s body was glorified at the moment of his Resurrection, as proved by the new and supernatural properties it subsequently and permanently enjoys. But during the forty days when he eats and drinks familiarly with his disciples and teaches them about the kingdom, his glory remains veiled under the appearance of ordinary humanity. Jesus’ final apparition ends with the irreversible entry of his humanity into divine glory, symbolized by the cloud and by heaven, where he is seated from that time forward at God’s right hand. Only in a wholly exceptional and unique way would Jesus show himself to Paul “as to one untimely born”, in a last apparition that established him as an apostle.
660 The veiled character of the glory of the Risen One during this time is intimated in his mysterious words to Mary Magdalene: "I have not yet ascended to the Father; but go to my brethren and say to them, I am ascending to my Father and your Father, to my God and your God."537 This indicates a difference in manifestation between the glory of the risen Christ and that of the Christ exalted to the Father’s right hand, a transition marked by the historical and transcendent event of the Ascension.
663 Henceforth Christ is seated at the right hand of the Father: "By ‘the Father’s right hand’ we understand the glory and honor of divinity, where he who exists as Son of God before all ages, indeed as God, of one being with the Father, is seated bodily after he became incarnate and his flesh was glorified."
While we may not have a full understanding of how this will look or is possible since there is a difference between the risen Christ and Christ who is exalted to the Father’s right hand, we can know that He is seated bodily in heaven through the hystatic union of God incarnate. Christ, the fully human part, did not just cease to exist.
Christ is acting forevermore as our high priest in the presence of God the Father.
Note, while I acknowledge that I do not see how this is possible, I think to say it is completely metaphorical, contradicts the catechism of the Catholic Church. God may not have a “right hand” as we understand it, but Christ’s humanity did not just disappear and cease to exist along with His divinity, which is what your statement implies to me. (If not, please accept my apologies, I blame the method of communication

. But please, also explain more fully

)
God Bless,
Maria