Will I be an SNCF employee if my project is selected for one of the stations in the call for projects?

No, you are completely self-employed and you manage your own business. Only the temporary occupancy agreement connects you to the SNCF.