I'm starting to wonder if Rios himself is real or if it's just a whole ship of holograms.
Maybe the "captain" whose brains he saw splattered all along the bulkhead was the real Rios!
His existential horror is he knows the "real him" is dead - and he can't join Starfleet because he's not a living being.