> if you have a climate-related degree, can you really compete with Stanford CS majors for a SDE job

For this specifically: Yes, depending on your extra curricular activities and interests. And if it was a graduate degree, then yeah almost certainly.