2FA with SMS protects against password reuse or leaks. It's my understanding that SMS is weak against attacks targeted at particular people while being sufficiently strong for the majority of cases.
In general, SMS is better than no 2FA, but it's weaker than OTP/OTH or a token like YubiKey or Titan.