Only if the message didn’t go out to Apple’s servers. That doesn’t help me when I know the recipient won’t be able to receive it (e.g. because they are on roaming or out of mobile data).

If you know you want to send an SMS you can tap it right after you press send, there’s a small grace period. I just did it.