Yes.
An active Oura Membership is required because Oura makes your detailed sleep and readiness data available through your membership. Without it, Oova cannot access the data needed for the integration.
If your membership expires, new data will stop syncing until your membership is restored.