Spoiler!!! ( I got spoiled )

A question For people who have completed the game

I somewhere read that in the end of the story Arthur Morgan dies, is rdr2 spoiled for me or its fine? Will it affect my emotional investment in the story?