It was fairly directly stated that Endless are solely the severed memories of someone's soul that can "live on" with autonomy within the system preserving their essence.
The aetherial sea, where "souls" go, seems to encompass all memory and soul combined as evidenced by Fandaniel (all forms), Emet and Hythlodaeus. So by what we have seen atm, Endless specifically do not go to the aetherial sea. They solely live as data within some super tech powered by Electrope. Their manifestations within this technology require cleansed souls to sustain. Erenville is just being hopeful here but he also wasn't present during our convos with Sphene or Otis. While Erenville said that, I also think he is aware of the consequences Cahciua is facing right now.
That is NOT to say however that at the time of corporeal death, there isn't a record that goes to the aetherial sea and one that can get extracted to be an endless also. We never actually see the process of what "going to the cloud" looks like at time of corporeal death but MAYBE we can get some inference from the attack on Tural when the soldier targets someone as they died and 2 orbs get absorbed, an orange one, and a blue white one. When we see it in Origenics, the blue white one is separated into a pure white and yellow looking one. So maybe there is something else at play there still.
As for Otis, he was an experiment that lead the way to create the Endless. He also confirmed to living a full life till he was gray, so the Endless we see in Living Memory should contain all memories up til he became Robo. Which only points to that he was probably one of the first if not the first successful Endless.
They clearly also made a copy of his soul and tested what options were available to them. The copy that got experimented on (before Queen Sphene's) become the endless Otis, written off of the memories up to that point and the other copy was either tossed away into the Robot, or they were trying to come up with a way of creating artificial bodies to supplement the corporeal form post death.
This is, imo, where Sphene's Crown comes in which allows her to body hop the Robo's in full Endless imagery compared to Robo-Otis. Robo-Otis is their attempt in merging the soul with an inanimate object which while successful is only early stage to their ultimate goal of bringing back Sphene in all her pre-death glory from long long ago. I wouldn't be surprised at this point if the crown itself maintains a copy of Sphene's soul / memory separate from the overall system.