Well damn.... Literally the same thing you described just happened to me. 2022 max tow 41k miles. Left me stranded a few hours from home too. Had it towed to the nearest dealer and they are telling me that the TCM and transmission valve body needs to be replaced.
Was hoping for something less...