Yes and no. Many developments in history writing (especially since the 1960s) have been concerned with understanding history 'from below' - that is, what was life like for people who weren't at the top of society. A famous text that helped kickstart this process was E. P. Thompson's The Making of the English Working Class, which did what it said on the tin - where did an identifiable (and self-aware) English proletariat come from? This is a story told very much from the perspective of ordinary Englishmen (and generally not Englishwomen), and seeks to explain historical change through the actions, needs and politics of ordinary people. Thompson was part of a historical movement heavily influenced by Marxism, seeing historical agency as being fundamentally rooted in class identity and struggle, bringing with it a broad concern with more 'ordinary' subjects. Today, these kind of perspectives are entirely mainstream in academic history writing - many historians continue to focus on recovering historical perspectives of those who were formerly written out or marginalised from traditional historical narratives, not just on the basis of socio-economic status, but also gender, sexuality, race, nationality or politics. Simply put, if you want to find a book that focuses on those like your great-grandfather who stayed on the Home Front to work during the Second World War, I can pretty much guarantee that such a book exists (most likely many).

One particular strand of these concerns that might interest you is 'microhistory', a genre that was especially popular in the 1970s and 1980s but is still going strong today. Instead of seeking to explore ordinary people's history from the top down - through big social structures like classes - microhistory starts from the smallest possible perspective, most often a single person's life. By exploring that life in detail, microhistory aims to uncover the complexity of human existence and culture in a particular time and place. These histories tend to be close to what you're asking for - ordinary people getting caught up in extraordinary events. Classics of the genre like Carlo Ginzburg's The Cheese and the Worms or Natalie Zemon Davis' The Return of Martin Guerre are widely and cheaply available, and may be worth checking out.

That said, it's important to remember the limitations of the historical record here. Archives are not neutral - we know much more about the lives of kings and queens precisely because they tended to control the means to create and preserve information. Generally speaking, archives hold information judged by those in power to be especially important or interesting. Those held to be unimportant or uninteresting are correspondingly poorly represented. As such, the further back we go, the less and less likely it is that we can point to documents or sources from the perspective of 'ordinary' people. Historians sadly don't have magic wands to conjure up the sources we want to read - while we'd all love to have access to the innermost thoughts of ordinary people from the past, we usually have to make do with much broader, impersonal sources.