yes and no, it depends on the community, ones like IWC, Supply generally only pick those who put them #1, SWO can be #1 or #2, SNA and SNFO really don't care.
at the end of the day it is all about best qualified, which for Supply means the higher GPA the better, the benchmark that is pretty accurate is the higher above 3.5 you are the better chance, the further away from 3.5 going down the more your chances go down, and if a person has waivers you can almost be guaranteed a "N".
To have a LOR/appraisal from a CDR/CAPT that was on the board and still not get picked up means there is something in that application that is bugging the board, or you may have a good application but not good enough.