If you have a really old house make sure you don't have vermiculite insulation which might make things way more expensive cause it likely has asbestos in it. Apart from that you can also DIY it but it's messy. Your state may offer incentives for doing it too.
https://www.energystar.gov/campaign/seal_insulate/attic_air_...
You'll still want insulation on the floor of the attic space, and seal off the living space from the attic.
From what I gather the main complication is keeping critters out while opening your attic to a substantial flow of fresh air. A pile of rockwool insulation sounds like a hell of a home for many small mammals, and bees can get past all but the finest of screen meshes. It seems feasible to diligently install screens on all the vents but it'll be a maintenance burden to keep them intact as the years go by.
Do you think attic air sealing, or more effective attic insulation would have a big impact? It does feel like the roof turns into a radiant heater in the summer.
(The only energy auditor available in the area is also in the business of providing the insulation, which is why I’m skeptical.)