I don't think there is any way a 2018 DNG spec will work with CS2. CS2 is over 10 years old, and Adobe has made huge changes since CS2. Camera raw (the version you need) will most likely not work with CS2.
Adobe DNG converter should not help much as it's designed to take a raw file and convert it to a dng, your raw files from the DJI drones are DNGs.
You might look at a program like rawtherape. It's a freeware program (last time I checked) and it supports most raw files.
About RawTherapee is a powerful, cross-platform raw photo processing system, released as Free Software (GPLv3). It is designed for developing raw files from a broad range of digital cameras and targeted at users ranging from enthusiast newcomers who wish to broaden their understanding of how...
www.rawtherapee.com
Paul C