It looks like you're new here. If you want to get involved, click one of these buttons!
When a page is marked as being Unpublished it should not appear in the sitemap under any circumstances.
I've had several occurrences where pages that were Unpublished appeared in the sitemap thanks to a bug in the Navigation system.
The page appears in the sitemap.
The fourth condition should never override the first condition.
In fact this begs the question why is there a Publish column under Navigation in the first place... a Hidden toggle is sufficient or call it Active/Inactive.