Media Collections and Attachment URLs

I want to embed a collection of images in one of my posts and I want each of the images to be clickable, in order to have it open in lightbox,

When I create the collection and try to embed it, I choose “Link to Media” but the images in the post rather point to the attachment urls and not to their individual full sized image.

This is contradicting my chosen option, but it is a further problem because I have enabled Yoast WordPress SEO option to redirect attachment urls to post urls.

So the images do not open in lightbox and when clicked they rather reload the post.

I am guessing this might be more a problem with WordPress than with the plugin