Christianity has usually misunderstood John 14:2,3
to mean something like this:
Jesus is going to Heaven to prepare mansions, luxurious large mansions for everyone. And they think for two thousand years Jesus has been there in Heaven preparing curtains, rugs, windows, and all the things that make beautiful physical mansions. Then He will come a second time and bring His saved people to their mansions in heaven.
This is a natural religious thought and not the revelation of the Bible.
"I've got a mansion, just over the hill top" is a popular song among some Christians.
"In bright mansion above" was also a Negro spiritual. about one day going to heaven from the slave master's mansion to the Christian slave's mansion in heaven.
While these songs have been comforting and sometimes sustained people in great suffering and sorrow, they were still short of the real revelation of John 14
The "many abodes"
of the "Father's house"
are the many redeemed sinners made living dwelling places of God even as Jesus Christ was the model, prototype man indwelt by God.
" ... so that where I am you also may be."
That is IN the Father and the Father in Him.
In the eternal plan of God there are to be "many abodes"