The user cannot just log out of Signal and have the app on other people's devices automatically fall back on SMS the way it works with iMessage?
Logging out might not even be enough, depending on the logic on Signal’s side. Do they use active devices, or just that an account exists?
I’ve only done the switch from iOS to Android once and I remember it was a pain for a few days until everything realized I didn’t have iMessage anymore.
For two weeks, messages will be shown as sent but not delivered, and after two weeks Signal will not let you send messages to that number until it reconnects to the Signal servers.
For comparison, Apple automatically sends all SMS messages via iMessage opportunistically, and if the user then switches to another phone, all SMS messages from iOS users will be silently discarded in perpetuity. This is a big problem because the recipient has no idea that they're missing messages, and also if they no longer have access to an iPhone, there's no way for them to deregister their phone number from iMessage.
https://selfsolve.apple.com/deregister-imessage/
They will also deregister you automatically after some period of time. What you described is the situation several years ago, but it's much better now.
In that case, Signal's current behavior would be comparable to Apple's, if Apple also deregisters you after a period of inactivity.
This became much more of a problem for me after they rolled out their shitcoin; suddenly my techie friends were just not responding to messages, and Signal as my main SMS app was not falling back to SMS for these folks.