Hollywood icon Pierce Brosnan has opened up about his grief after his wife Cassandra and daughter Charlotte both died after being diagnosed with ovarian cancer, with the star calling it "overwhelming"