The 92-year-old singer took to social media to clarify his status after his brother said Frankie “will now retire”