Your circuit should work. The motor should be able to be driven from 230VDC unsmoothed from a bridge rectifier. I've seen a similar motor used in a vacuum cleaner to drive the brush.
Did you use a smoothing capacitor? If so, then perhaps it's that which caused it to blow up, since it would increase the RMS voltage to the motor.
Did you measured the voltages with a true RMS meter? If not, then you can't trust the reading.
Unless the motor is in a plastic box, with the load driven with plastic gears, then the motor's case should be connected to earth, otherwise it will present a shock hazard.
Lastly, the motor's specification doesn't add up. It says it's rated for 500W, when the current draw is only 0.22A, which would be 50.6W of power draw and the power output will be be 31.6W, as the efficiency is just 62.4%, which is typical for a small, cheap, brushed motor.