Adele looked gorgeous in this plunging off-the-shoulder red ruffled velvet gown at the 2023 Grammy Awards