Add me to this list...my '22 MYLR Ryzen has had this oddity more times than I care for. I've read posts about the speed/wheel sensor and front motor being replaced but in my case, tech support is declining the service visits detailing that this is a known "software" issue and will be fixed in a future OTA update.
I've had this happen while parked, while in auto-hold when driving but at a stop sign, in motion/driving and in motion/autopilot.
The barrage of errors and the lack of power when this happens is really annoying but I am usually in city driving where its easy (but inconvient) to pull over, lock the car, wait a minute and then the errors are cleared (support told me this is just as good/quick as doing the two button/two button and brake reset procedure).
Have now had this happen across many version of the code (am on 2022.12.3.1 currently) and it has happened two days in a row in some cases, and others, 2 weeks between experiencing it.
Your post covers the most like what I'm seeing, so pasting my screenshot here (I take a copy of each cleared example to share when I create my next service ticket.
BTW: although the loss of power is pretty intense, its nothing to compared to what coasting feels like when regenerative breaking is not working. This car feels like a glider airplane...seems like it coasts with no loss of speed with great aerodynamics/not much drag compared to old cars in my past, it's a trip!