The death of his father Ben in 2022 (pictured with Stern and mom Ray in 1993) as well as close friend and stylist Ralph Cirella in 2023 and longtime agent Don Buchwald last year made Stern 'question his future' the insider revealed