This is
not a missable achievement, but I had to go back and finish this one off after collecting them all because I didn't discover the memories of each artifact as I collected them.
You can tell if this happened to you if the achievement tracker doesn't show 100% even though you have 42/42 artifacts.
If you're like me, you can fly through your artifact menu and hit
to View Details on the artifact. If you've heard the Memory, it'll give you the option to press
to play the memory, and you can
back out and skip that one. If it's one preventing you from achievement unlock, it'll prompt you to rotate the artifact to find the memory.
You do not have to actually listen to each memory, you just need to discover the memory.