Car wont take gears or accerlate

My car has had shifting issues in the fall of 2023. The code that I got at
Autozone was "P0717" and said to replace the Transmission Speed Sensor. I
replaced but sensors and the problem got "minimized" but not fully resolved.
Last week my car would have huge issues shifting from the second to the third
gear. I thought maybe the replacement part is not sitting right or also went
faulty. I changed them again. The morning commute was "okay". However,
when I drove home the car at higher speeds on the expressway wouldnt shift
at all anymore, I had to stop at the shoulder and I barely made it home. The car
wouldnt shift AT ALL when stopping or standing still at a red light or stop sign.
I had to shut off the car and restart almost every block to get the car to move.
Everytime I would stand still the RPM would go up but the speedometer
wouldnt move an inch. I noticed today that when I move the stick from P to R
to N and D that I can notice how the transmission engages but that
engagement stops within 20-30 seconds. I can let the car in Drive and release
the break but the car wont move at all.

The weirdest thing is, that ever since it got SUPER BAD, the check engine light
wont turn on.

In addition, for some weird reason this car wont turn on when I have driven it
for at least 30min straight and leave it off for more than 5min. For example, if I
come back from work and take a 10min break at home and then want to go to
the gym, the car would not turn on. (battery is brand new, no alternator codes).
I would need to wait another 30min in order for it turn on and most often also
press the speed pedal get it to turn on. I dont know if this has anything to do
with the shifting too...