Sandler said it was bittersweet to forge on in the project following the death of actor Carl Weathers portrayed the role of Derick 'Chubbs' Peterson in the original, in February 2024