which grand narrative is most significant in how we live our lives,

A pertinent question. My view is people have been telling themselves many of the same stories for centuries.

and is it necessary to choose between them?

I don't think you must, but many do. I am increasingly interested in knowing those told by my ancestors, and even those of people who have been living in my part of the world. Strange expressions of these stories appear in my very sinews.