Board to Board interfacing connectors
In order to know if connectors are good for repetitive use, look at its specification : it generally specifies how many mating cycles the connector can support.

Regarding an alternative solution, you can also consider to create your own "testbench" using a "bed of nails".

Personnaly I did so using "spring probes".  I prepared the PCB with several test pads distributed on a 2.54mm grid.  That allowed me to solder the "spring probes" on a downsized standard PCB card board with standard 2.54mm pitch. I wired the probes to a more regular connector fitted on the same "test PCB"

Further, I designed and 3D printed a bench in which I slide (and fix) this "test PCB".  The board under test (design) is placed on the top.  Guides help me place it at the appropriate distance and position easily and I have a method to keep it in place.

The spring probes that I used can support one million cycles - way beyond my needs.  The test pads do not need to be through hole and do not need to be colocated - just at common distances if you want to build your test pcb by hand.

You can also draw your test PCB in a CAD tool and produce it like any other card - in that case you only need to make sure that the locations match.

By the way, the same system is used as a production bench where the PCB under test is kept into place by hand just for the time needed to produce the test report.