Is obtaining Multiple PhDs in two different and barely related disciplines detrimental to the career? My situation is like this: I have tried to obtain an MS in CS/CSE but failed. Now, I am studying an MA in Education and planning to get a Ph.D. in Education. After that, my plan is to get a Ph.D. degree in data science. 

Now, why this strange plan? The answer is, STEM pays money, but STEM research is hard. So, first I need to have a guarantee that if I fail to obtain a degree in data science, I always have something to fall back on.

Suppose, you are seeing my resume, what would your first thought be? Is having PhDs in two different disciplines counterproductive to each other? If I apply for a job in academia/research, would I be seen as a pariah in both education and/or STEM?
I think you're planning too far ahead, and are definitely overthinking this.  Most people find a PhD a pretty grueling process, generally well beyond expectations.  My feeling from having gone through it myself, and knowing many others who have, is that the odds are very high that you'll have no interest in going through it a second time.

Get a PhD in the field you actually want to work in.  Finishing a PhD is hard; finishing a PhD in a field you're not very interested in is even harder.  Put your energy into doing one field well, rather than spreading your energy out and doing two fields at a lesser level.

But to disregard that and answer your question, I think people without PhDs would probably be impressed, while people with PhDs would think it very strange, and not necessarily good.  But I suspect there would be pretty wide variance in opinions, depending on surrounding circumstances.

Edit: I should add that Master's Degrees make a pretty good supplement to PhDs.  So if you finish this MA in Education and then move to a different field that you can plausibly supplement with Education, that would be normal and probably pretty effective.  But again, plan to do your PhD in a field you're interested in.