Sounds to me like the activation, SFC, DISM and update errors are probably all one problem. If Settings won't even open and SFC can't repair things, the Activation page not loading is more likely a symptom of the broken install than a lost license.
The one thing I'd check is how you got the laptop. If it's refurbished or used to belong to a company, it may have been activated with a volume license, and that could explain it coming back after the reset and then dropping off again. If you can get an admin Command Prompt open, slmgr /dli will show you which kind it is.
The SSD not showing up is the usual thing with 11th gen Intel like your i7-1185G7. Setup doesn't have the Intel RST/VMD driver built in, so it can't see the drive when the BIOS is on RAID On. AHCI/NVMe normally gets around that, so since it didn't, I'd go back to RAID On and load the driver. While you're in the BIOS, also check the M.2 PCIe SSD port is enabled in the storage settings.
That Dell .exe you've got can actually be extracted. Run it on any Windows PC and choose Extract instead of Install, then copy the folder to your USB. At the drive screen in Setup click Load driver and browse to it. You're looking for the folder with VMD in the name, with iaStorVD.inf inside.
To tell if it's the driver or the drive, press Shift+F10 at that screen, type diskpart, then list disk. If the SSD shows up after loading the driver, the drive's fine. If it still doesn't and the BIOS doesn't list it either, I'd start looking at hardware, like reseating the SSD. Passing ePSA is a good sign though.
One warning, a clean install wipes the drive, so back up anything you need first, and have your BitLocker recovery key handy if the drive's encrypted. For the install, pick Windows 11 Pro and choose "I don't have a product key". If the Pro license came with the laptop from Dell, it should activate by itself once you're online.