Where they help
Preview databases are useful when you want branch-specific testing, a safe place to reproduce a bug, or a disposable environment for experimenting without touching the main project database.
They are also great for the very normal workflow of trying something questionable on purpose.