I have a 2023 Silverado 3.0L with 25,000 miles. The truck had been shuttling back and forth, driving in traffic, but had been intermittent recently. Over the weekend my truck when cruising at 45mph hesitated to shift to 5 or 6th gear, dropped gears and went into limp mode. When I finally limped back home and had to back in once, putting it in reverse, the truck came to a sudden stop, engaged the parking brake, and said, "Unable to complete that action." I have code P0747 twice and P0700. The check engine light is on, service transmission has been displayed, and oil & transmission fluid are now leaking. I got the engine notification as well. How cooked is the transmission/engine?