Have you played any other Souls games before? Souls lore is what you make of it, because everything else is incredibly straightforward in terms of the plot.
Play the DLC if you find it fun, I doubt you need to play much more than the base game because even if there is a direct link it's a souls game.