Do we get the sexuality of historical characters wrong?

The film, The Favourite, about Queen Anne and Sarah Churchill has raised a question about the queen's alleged lesbianism. It is also a question that has been asked about Queen Christina of Sweden. Here is a discussion about how far we can impose our sexual categories on people in the past. The conclusion is open-ended, but the issues raised are very interesting. (I just wish the author of the piece hadn't kept inaccurately referring to the Duchess of Marlborough as 'Lady Sarah Churchill', but then I'm a real pedant about aristocratic titles.)

Whether or not Anne was a lesbian, there were scurrilous ballads written about her relationship with Abigail Hill. You can read about them here. But as they were probably paid for by Hill's great enemy, Sarah, Duchess of Marlborough, they aren't necessarily a fair or accurate depiction of what went on between the two women.