Cyndi Lauper gave a speech thanking President Joe Biden for finally allowing Americans to "love who we love".