Drop D sounds so different because the lowest string has changed from an E2 to a D2 which is a whole tone lower. This allows the guitarist to access a D note a whole octave lower than the D note available in standard tuning.