so no more main lore for these characters?

for all the characters that are dead, for example I just found out that composer died in the main story, they won't have anymore story content? once they kill their characters...they're gone? or do they end up having side stories in events? I'm new to this game but I cannot find a proper answer anywhere