As mentioned, most naval officers in the non-Naval Special Warfare or Expeditionary units will not handle a weapon, for about all of their career, with the exception of being in limited billets/roles (i.e. as an officer of the deck, antiterrorism watch officer, or visit, board, search and seizure officer) and those are typically performed as an ENS or LTJG. You are looking at maybe 1-3 more times on a range. Honestly, as you become more senior no one is going to care if you rate a medal or ribbon…maybe if you have neither, but still likely to not really care. The bigger concern is are you affecting a watchbill and watches (readiness) because you can’t carry an arm. Furthermore, as a naval officer, the shiny gold pin(s) will carry more weight about whether you are a competent officer than pistol/rifle qualifications. It goes without saying, that if the opportunity affords itself to requalify and shoot better…by all means…but it should be done for greater proficiency and readiness, rather than for the medal or ribbon.