Been through this decision on my last two builds and helped a buddy with his, so here's what I learned the hard way. The big thing is installation quality matters more than the product. High density fiberglass performs great on paper but only if the batts are cut clean and fit tight around every wire, box, and corner. Rockwool is more forgiving because it's stiff and you can trim it with a bread knife and stuff it in without it slumping. If you're hiring a crew, ask who's actually doing the cutting and how they handle odd cavities. A sloppy fiberglass job loses way more real world performance than the spec sheet difference between the two.
Sound and fire are where rockwool quietly wins, and resale buyers seem to like hearing it's in the walls. Fiberglass wins on price and it's lighter to haul upstairs by yourself.
My honest take: if the price gap is huge and you trust the installer, dense fiberglass is fine and you won't lose sleep over it. If the gap is small, rockwool is the easier long term choice. Either way, air sealing the envelope before insulation does more for your comfort than picking between them.