You only have collections configured for posts that have either the tag ‘post’ or the tag ‘newsletter’.
Any posts that don’t have one of these tags won’t belong to a collection. A collection is what gives the post a URL.
I’d guess your post doesn’t have either of those tags, and therefore the 404 is expected?