sounds like the transmission is stuck in mechanical limp mode, Check the ATF level with a 722.6 dipstick (it does not come with the car - you need to buy it as a tool)

if the level is good and the ATF is correct type and you still get hard shift from N to D with clunk and stuck in 2nd gear only, a deep level scan is needed to isolate the issue, usually its a conductor plate gone bad (broken speed sensors), after replacing it the only way to clear the transmission computer codes is with benz capable deep level diagnostic tools which connect to the 38 pin connector in the engine room fusebox.

__________________
2012 BMW X5 (Beef + Granite suspension model)

1995 E300D - The original humming machine (consumed by Flood 2017)
2000 E320 - The evolution (consumed by flood 2017)