The legendary singer was best known for her enduring hits like “Respect” and “A Natural Woman”