For acoustic (sound) insulation you need density, ie weight. None of the PIR foam boards are particulary heavy.
If you’re replacing your ceiling, it would be better to double up on your plasterboard, use something like Rockwool Flexi within the joist, while remembering to leave an air gap, which...