Yes, the saints who are alive and in HIM are seated at the right hand. When we die our bodies lie dead, our souls got to hades, and our spirit (if we are born again) goes back to Father.
FYI… the “great cloud of witnesses” you referred to are those listed in the beginning of Heb 11… they are “witnesses” to the idea of faith.
Are you speaking the theology of a protester? Is that Calvin or Luther? Its irrelevant because its of ONE man and contrary to what the Pillar and Foundation of Truth 1Tim 3:15 and Jesus.
This final dogma of the Church of Christ is what happens infallably when you die:
XVI. The Last Things
In the present order of salvation, death is a punishment for sin.
All human beings subject to original sin are subject to the law of death.
The souls of the just which in the moment of death are free from all guilt of sin and punishment for sin, enter into Heaven.
The bliss of Heaven lasts for all eternity.
The degree of perfection of the Beatific Vision granted to the just is proportioned to each one’s merit.
The souls of those who die in the condition of personal grievous sin enter hell.
The punishment of hell lasts for all eternity.
The souls of the just which, in the moment of death, are burdened with venial sins or temporal punishment due to sins, enter purgatory.
At the end of the world Christ will come again in glory to pronounce judgement.
All the dead will rise again on the last day with their bodies.
The dead will rise again with the same bodies as they had on earth.
Christ, on his second coming, will judge all men.
If you need more a dissertation try looking up the word death or ESCHATOLOGY in the CCC here:
scborromeo.org/ccc/ccc_toc.htm
or the Holy See site here:
vatican.va/phome_en.htm
or the Catholic Encyclopedia site here:
newadvent.org/cathen/index.html
Does that move you to the truth?