I created a non-trading real estate company (SCI) with my son. I want to give him the bare ownership of my shares. Will I retain my status as a partner?

No. Case law holds that “the usufructuary of company shares cannot be recognized as having partner status, which belongs exclusively to the bare owner” (see Cass. Com., advisory opinion, 1 Dec. 2021; Cass. 3rd Civ., 16 Feb. 2022, No. 20-15.164).
Moreover, an SCI must have at least two partners (Art. 1832 Civil Code). As your son would become the sole partner, there is a risk that “any interested party may seek the dissolution of the company if the situation is not remedied within one year” (Art. 1844-5 Civil Code).