Help! Husband will fail!!

Hey guys. So my hubby has a good paying job currently. He has his masters but isn’t really using it for his field. He is so tired of his job and he’s also miserable where we live. We plan on moving when I’m finish school. We have two little babies also. We can’t really afford for him to stop working right now so he planned on going back to school for nursing after I’m done. But he has his Masters in public health already. He has anxiety issues doesn’t perform well under stress, And honestly he really lacks leader ship role. He’s an amazing father a great guy but he can be a little lazy and he just doesn’t have the go get em attitude that you need to thrive in school at this juncture in our lives. I don’t want to be in more debt then we need to because I know in my heart he will not finish. I have tried talking to him so many times about other career option since he has his masters already. But he is an extremist and very impulsive he doesn’t want to hear any other option I have other than him going back to school for nursing. How can I be a supportive spouse but also have him realize this isn’t the right decision. I don’t want him to know I don’t think he can do it. That would probably squash his hopes and dreams but to be honest he hasn’t done anything to prove that he can accomplish this at this juncture in our lives. He’s miserable all the time lazy and depressed. What should I do?

Edit: I do not confuse depression for laziness. He has always been lazy. His parents have done everything for him his entire life and he is a bit spoiled. He recently just became depressed because of where we live. He needs to be more active and social and we kind of live in the middle of nowhere. Also I am trying to be the best wife I can possibly be I am not trying to discourage him at all so please don’t bash me. I’m just trying to keep our family strong and together