This is what you remember; but it is NOT what the text actually says: Yes, we are of good courage, and we would rather be away from the body and at home with the Lord.
2 Cor. 5:6,8 AV:
6 Therefore we are always confident, knowing that, whilst we are at home in the body,
we are absent from the Lord:
8 We are confident, I say, and willing rather to be absent from the body,
and to be present with the Lord.
The context makes it clear that temporally, the flesh-and-blood body that is currently my vehicle cannot occupy space in heaven, but in heaven, God has intermediate housing to sequester the "me" of me and keep it safe until it is to be reconstituted with another real, but spiritually energized vehicle that will have a very similar humanoid bilateral appearance to that of Jesus on the Emmaus road, or with His disciples in the forty days prior to his final transition from the earthly sphere to the heavenly one.
But I do hope there is some raspberry pie and ice cream there.