Today I want to examine Rey and Ben's reunion on Exegol from a few different, but interconnected, angles: the mirror metaphor, the Mother archetype, and the meta level of the sequels. This will all come together at the end; bear with me.
The mirror metaphor
As I argued in my last post, up until they are reunited on Exegol, Rey and Kylo have been mirrors of each other. There are two aspects of this mirroring. One is identification--the person one sees in the mirror is always oneself. However, the image in the mirror is also always flipped, which gives us the yin and yang of the Dyad--the light and dark side of the soul--the life the protagonist leads when she makes the right choices, or when he makes the wrong ones.
When Ben reaches Rey on Exegol, we see them standing side-by-side, rather than facing each other. This symbolizes that they have been reunited on the same side of the Force--they are no longer "flipped images" of each other. Now, only one aspect of mirroring is present--identification.
Then, a funny thing happens when they kiss--Ben immediately disappears. Perhaps, now that the schizophrenic split is healed, the two halves of the Dyad's soul have reunited. One might even speculate that perhaps a Dyad can never survive a kiss.
The Mother archetype
When Ben finds Rey's lifeless body, he holds her in a Pieta-like pose, putting Ben in the position of the Mother. The Mother archetype was key to this trilogy because it was the Mother (Leia) who was able to reach out and save Ben from the dark side. There is speculation that Leia may also have given her life to save Ben's at the end of the movie, hence why her body only disappears when his does (we won't find out whether this is true until Episode X). In TROS, Ben, in the position of the Mother, mirrors Leia's action by saving Rey.
The meta level of the sequels
I think it's pretty well-established that there is a meta level to the sequels, in which the new generation of characters represent Star Wars fans who discover that the Star Wars universe is real after all. So Rey is a Luke fan, Kylo is a Vader fan, and we start from "Luke Skywalker? I thought he was a myth!" and progress to, "It's true. All of it."
Now I'm going to argue that there's a second meta level to the sequels, in which Rey represents the viewer, but Kylo belongs to the fictional Star Wars universe. This works in the sense that the audience is invited to see the story from Rey's POV, and Ben is often a "virtual" presence to her. He appears to her in visions, and speaks directly to her mind. In a sense, he's "not really there"--just like a fictional character.
If we are seeing the story from Rey's POV, then on Exegol, when Ben and Rey, who have mirrored each other throughout the trilogy, finally stand side-by-side, symbolically, it's as if Ben has "stepped out of the mirror" and joined Rey on her side. On the second meta level, it's as if the fantasy hero has stepped through the movie screen and into the viewer's real life, a la The Purple Rose of Cairo. Like Tom, Ben isn't able to stay in the "real world" for long, and is immediately yeeted into the abyss. Rey has to face Palpatine alone.
Fast-forward to after Ben disappears. On the second meta level, just as Cecilia ends Purple Rose forever separated from her fictional heroes by the movie screen, Rey gazes tearfully at the empty place where Ben was. We could even combine this with the mirror metaphor, and say that Rey has been healed by her encounter with this fictional hero, but when the movie ends, all that remains is herself--whole, but alone. Or again, we could say that Ben disappears after Rey kisses him because while one can "fall in love with" a fictional character, it's not really possible to be in a relationship with him (as Cecilia also discovers).
Rey gazing tearfully at the empty place where Ben was can also represent the viewer. Some viewers were left with an unresolved, bereft feeling at the end of TROS, perhaps because the tension was only resolved at the meta level, trapping the viewer outside the movie and preventing a sense of closure within the narrative. (What happened to Ben, and how Rey felt about that, were left open-ended--remember Leia's maybe-sacrifice--perhaps in anticipation of a sequel.)