DROP WITH PURGE should be disabled by default

### Describe the bug

As mentioned in #774 and elsewhere, DROP WITH PURGE is currently somewhat unreliable. While there is some ongoing work to make this operation more scalable and robust, we should disable this by default for the time being. A flag was implemented in #270 to disable DROP WITH PURGE, so we only need to flip the default now.
