Sacred Haven of Debauchery

Yes, it's partly ironic wordplay.
On the other hand, wordplay is comparable to spam, so it's unlikely to have a strong negative connotation, at least in the way we usually use the term.