Misleading results from low-resolution spectroscopy: From galaxy interstellar medium chemistry to cosmic star formation density