HONDA ACCORD 2002 4cyl AUTOMATIC
https://youtu.be/QDHeeORPe44?si=f3I63HFwHflufj7n

VIDEO PLS WATCH^^^^
The noise is mainly coming from near the transmission

it’s not a power steering, I already fixed it. The noise went away but this one stayed.
I do get codes for 3rd pressure switch, vtec solenoid, and a transmission one

the car struggles to switch gears and keep the gear (I think, yes I think) and it struggles to find the first couple gears then when I accelerate it goes straight to 3rd

I plan on getting a new one soon, but should I fix the transmission on this? Or just scrap it

the 2 second video is me running to turn the car off cause it sounded like metal being torn inside something

please lmk, a while back a mechanic told me I needed a new water pump soon. But I felt like he just wanted to get me to spend some. I’ve recently found a more trustworthy better experienced mechanic, but I won’t be able to go to him until the car is able to drive

this all started when one morning I switched from N to R and heard a clink at the bottom