In D5 at least disabling modules does not remove tables. You have to use the Uninstall function for that and the module has to provide the hook.
Disabling modules anyhow can certainly lose data. Even without uninstalling. I disabled the Ads module on a site once, I believe, and data was lost which we were forced to restore (what we could) from backups.
Fred