I took the car to a auto shop and got the battery condition check. Result came back with "Replace Battery"

I replaced the battery with a top end expensive one with I think 780CCA.

Car still will exhibit the same issue in the video above where the car WILL crank but then revs drop and die, unless I accelerate alot during startup.

Driving the car I feel it has a little more response overall when gunning it! but maybe thats just my head playing tricks coz of the new batt but I honestly feel like its more responsive.

Anyway took it to my mechanic and pulled the following codes:

P0446
P20D4
P0101
P0102
P0453
P203B

He said most likely a lot of them are a result of one going bad, the rest pull up codes until that one part is fixed.