Marilyn Manson (pictured in December 2019) sparked controversy as he appeared at Black Sabbath's farewell concert on Saturday night