The 2020 referendum had a very obvious split where one side of the island voted to remain and the rest voted for independence: https://en.wikipedia.org/wiki/2020_New_Caledonian_independen...
Subsidies and the move to more local governance probably mostly benefit the area around the capital Nouméa, which is of course on the side that voted to remain.
I wonder how palatable a compromise would be where only part of the island becomes independent.