I tried to edit the above post but I couldnt, so I'll just reply to myself. Sorry, I haven't been on AirWarriors since I left the pipeline years ago.
Let me give you a better picture of what DQing will look like.
You'll probably get stashed at a training command (I was at the HITU at NAS Whiting), and you will await a POCR board (which is sort of a redesignation board).
You will know ahead of time which communities are recruiting (EOD was recruiting when I DQed, as was SWO and IW). This all varies wildly per year group and there is no way to know what will be available.
I had a Computer Engineering degree and IW was interested in me, but I wanted to leave the Navy. I called up the IW Community manager and just told them, "I am not interested in IW." and they respected that.
I was OCS, and maybe that has a lot to do with it, but when forced to choose communities for my POCR Board, I proactively reached out to those communities and told them I was just wanting to get out, and to please not select me for redesignation. I knew some Naval Academy and ROTC dudes that were in similar situations (Some just failed flight school), and they also ended up getting out pretty easily. This was back in 2017.
The end result was that I ended up getting out of the Navy as an O-2 with 90% GI Bill.
Not great, not terrible.
I wouldn't worry about it. It probably won't happen to you.