I am not sure I would want to fly form in IMC or at night in a COD either. Did your CAG hate your squadron or something? I don't think any C-2s are flying at night at the boat right now. Have fun leading studs at night, at least I had goggles when the other guys didn't, helps with self preservation.
Long story....back in the mid 90's, the three COD squadrons (VRC-30/40/50) were supposedly a mess. They were made up of pilots from various communities. They also didn't have a warfare designator and thus any Navy pilot who selected COD's and stayed COD's were generally destined to remain an O-3 and find themselves out of a job at the end of 10 years. So somebody up high (O-6 and above realm) got the idea to turn COD's into a more disciplined, refined community with aviators that could land on the boat at night, fly form, do SEAL para-drops (though that was happening anyway as I understand it), etc.
In comes CDR Baron Asher...a fixer and thus an . He was the XO of VRC-50 when they de-commed. He then became the XO/CO of VRC-30 and led the way for COD's flying from the boat at night and staying onboard during deployment. The idea was simple enough, save money, have COD's available day/night for any sort of logistics or specops mission, change the warfare designator, etc. BTW, the standard budget for a COD det for 6 months is around $1 million dollars. The budget for a COD det staying on the boat for 6 months was $50,000, quite a bit of savings. So for my first two deployments, I was on the boat 9 of 12 months. Though by the second deployment, we had stopped flying night at the boat.
In the end, the constant night flying wore our planes down...remember, only 39 C-2A(R)'s were built and the round the clock flying (night FCLP/CQ) was increasing the number of landings. Matter of fact, we flew at least one to the bone yard while I was at VRC-30. At the time, COD's were not being SLEP'd so when the new front office took over after CDR Asher, they proposed to stop flying night at the boat, which was readily agreed upon. Now, only VRC-30 and its DET-5 in Japan did the night thing, VRC-40 kept business as usual. However, once we stopped flying night and staying on the boat, DET-5's CAG like the night option and kept it going until 2003 or so. We stopped flying night in 2000. As an FRS IP, I still had to go to the boat at night with nuggets and a few CAT II types. I've got about 150 night traps, left and right seat.
Thing is about staying on the boat, we rarely, if ever, did any night logistics on deployment. As I recall, 90% of our night flying was an airborne respot, rarely any logistics and by the letter of the law, we could not fly pax at night unless it was SEALs. We never did para-drops with the SEALs while on deployment either...well, except a few drops in Kuwait when the ship was in port. So the ship was in port and we flew, great. We did plenty out of San Diego but it was just practice. VRC-40 did more para-drops than 30 ever did, at least that's my understanding. That went away too as somehow, the higher ups decided that it put too much stress on the aircraft....maybe the ramp but that was never an issue. That was a call made by someone (Admiral Zortman) who never looked into the effects of paradrops (which in the end, there really isn't any according to Pax River), just made a blind decision to stop things. As COD drivers, we enjoyed flying them, we dropped from 500' to over 10,000' and the SEALs like our platform.
The best thing to come out of it was COD drivers can now go CODs, stay with the community and march right on up to O-6 if they get a command, or O-5 if not. A lot of work but us VRC-30 folks in the mid 90's to make it so. I for one always though night flying around the boat made you a better aviator, though as unpleasent as it was in the COD. VAW-120 just had the first COD only guy to be its skipper and I'm sure DWOO is probably trying for a CAG billet. He also has 300 hours in the Tomcat as he was CAG-5 paddles as well as AIRPAC paddles. DWOO is not the norm for a COD guy by any means. As far as I'm concerned though, being a COD skipper is like being the smartest kid with Down Syndrome, it's just not that big a deal.