Americans can still apply for refugee status. That agreement makes it so if you come to the US and Canada as a refugee from a third country, you can only apply for status in the first country you entered.
US Citizens are still eligible for refugee status, assuming they meet the other criteria.
If you're in the LGBTQI+ Community and need refugee status here, check the link below; https://www.canada.ca/en/immigration-refugees-citizenship/services/refugees/about-refugee-system/2slgbtqi-plus.html
You'll also find support with the UNHCR (United Nations High Commission for Refugees) and the Rainbow Railroad.