I was Mil-Mil and know a few Mil-Mil and here are my $0.02:
1. Colo works differently for Officers versus enlisted. As an officer, your timeline for hitting career milestones is much tighter and there are fewer positions. If you go SWO, you will likely be gone most of your first 4 years at sea in order to get necessary qualifications and meet career milestones. Because of the need to manage your career, you will likely have to make very serious decisions about which ships and duty stations to choose in order to progress. Remember that you have a maximum of ten years to make O4 or you'll get booted from the Navy.
2. You or your husband will likely need to geobach at some point. You need to decide if y'all are okay with that and if either of you are okay being a single parent, even on sea duty. The SWO community is not very forgiving when it comes to making exceptions for families; this is one of the big drivers for why so many leave the community. Again, this is driven by the need to hit career milestones in order to make you qualified for O5 command around the 15-16 year mark.
3. If you are Officer-Enlisted, there is a high likelihood that his detailer and yours will not talk to each other. I've only seen this work well within relationships where the officer is AD and the enlisted spouse is in the Reserves, or the officer is a prior-E chief and now an LDO or CWO and the spouse is a Chief. This will make things much more flexible and increase the likelihood that communication channels will remain open. Again, this is driven by the fact that PERS-41 doesn't much care about enlisted detailing and is focused on making you eligible for O5 command.
4. Before making the decision I would recommend contacting the PERS-41 community manager and detailers and getting their opinions.
5. Eventually, you and your husband will have to make the decision about who's career comes first. Unless you never want to see each other or live together, you will eventually need to make the decision about who takes the less favorable duty assignment that propels their career forward and who takes the non-career-enhancing duty. Because of how tightly you need to manage your career as an officer, you will probably take the front seat. You need to have a serious discussion about whether you and your husband are willing to put your career first. This means that he will likely lose a lot of autonomy when selecting orders as the needs of your career will HAVE to come first.
From my own experience and what I've seen, the SWO community is extremely hard on Mil-Mil folks and is not forgiving when it comes to colocation. I think it played a major factor in the demise of my own marriage as well as many others. As you might imagine, I would not recommend both of you being on Active Duty as Mil-Mil. If you are intent on re-joining the Navy, I would recommend one of you being in the Reserves.
EDIT: Forgot to mention that as an officer you will need to get a Master's Degree at some point in order to make O5. The best option is to go to the Naval Postgraduate School, the next best is to do the split shore duty option, and the worst is to do night school and/or distance learning. As far as I know, there are ZERO CS billets in or around Monterey. If you choose the DL option, most people get an MBA from a degree mill which check the box but are worthless outside of the military.