I think comparing the two is innately a flawed premise, because they’re clearly not the same form of time travel. The methodology of time travel in both First Contact and Picard altered the Prime Universe’s history, and did not create divergent timelines, and Nero did exaclty that when his time travel created the Kelvin Universe.
The Queen took her sphere back in time in first contact, and then the Queen took the LA Sirena back in time in Picard.
Different time drives, but same pilot.