Evaluating Uncertainty Quantification approaches for Neural PDEs in scientific applications