Is insulating suspended floor void with spray foam effective in reducing noise?
I believe that rock-wool would give better results. 

That much spray foam is going to be very expensive...and messy, especially if this is a DIY job.