A US Navy warship commander was relieved of duty over a ‘loss of confidence’ 4 months after he was photographed firing a rifle with a backward scope