Yes, the connectors are fragile, but I have disconnected/connected cameras very often, and even outdoor.with Pi Zero mounted on RC airplane. Sometimes the ribbon cable got disconnected even without opening the connector by too much g-force of crash landings. Just opening connector, inserting ribbon cable and closing was all that was needed, and recording videos on next flight was done without issues.
One of my many Pi's had a broken connector, and it was mounted firmly and I did not want to change it. I just took the black locker of another Pi's CSI connector and transplanted it to that Pi without issues.
Summary: fragile yes, but surprisingly rugged, handle with care, transplantation from one Pi to another possible.