I’m not familiar with the detail of Scottish Building Regs, if they are similar to English then if you’re upgrading insulation you should, legally, be doing it to the current regs, if that makes any difference to you. To fit it in the ceiling void you would not have enough insulation with rockwool, so Kingspan etc is the way. In some ways it’s easier but you have to cut it to fit exactly between the joists, which are probably not exactly the same distance apart.
As I understand it you’re insulating the floor of the loot and the pitched roof – so that’s neither a warm loft nor a cold loft, but somewhere between. I considered doing that, but the Approved Docs for English regs don’t cover it – in the end, because I have trussed rafters, I didn’t do it as cutting the Kingspan around all the diagonals would have been a pain.
Are there any cables in the void? If you insulate round them the current rating drops.
Before you take down the ceiling, are you sure it doesn’t have asbestos? Anything like Artex will almost certainly have it, ordinary plaster before about 1980 might.
I don’t follow what you’re planning for the second loft. I would guess you need to leave a ventilated space between the insulation and the sarking boards, ventilated meaning it has vents in the eaves and at the ridge, not just a space.