Rock superstar Meat Loaf dies at 74