If we're just sandbox playing in my world, I would absolutely love a break from forever DMing. In our horror campaign, however, someone else DMing could risk unintentionally breaking it since it's such a unique setting/story). I think once the campaign is over I'd be all for it.