I think they are extremely rare, and I would rather just use my mobile data instead of giving them my phone number.

Definitely does not happen on "free trials" on in-flight Wi-Fi for obvious reasons.

A now deleted comment reminded me that this is mostly for in-flight wifi where it makes much more sense. Mostly no SMS there either.