If shifter rod bushing is worn, the NSS contacts can still be in N position even though the trans is in Drive gear.... and if they are , there is a rev limiter circuit for N and P.
When you shift manually you are not having the problem because the NSS is not retaining that position.
Just a possible consideration from what you have stated you have done to get it to work by shifting manually.