The Irish pop legend and TV star passed away with her famous sisters by her side