Yes. The concept of ‘normative’ has for some time now been presented as if it is inherently bad within academia. But… actually, it’s far more nuanced than that.
It all started out as a trying to make room for difference thing - broadening out social norms and changing practices that excluded people on the basis of disability, race, sex and so on.
But, things like queer theory seem to be obsessed with valorising ever more extreme ‘transgression’ - particularly sexualised transgression - and presenting anyone who isn’t up for fetishistic or niche stuff as ‘untight’ and ‘oppressive’.
Thing is, we live in a society. Social norms fulfil very important purposes in society. Boundaries are important - these can be absolute (hard no to pedophilia or rape in all circumstances, for example), spatial (fine in the privacy of your own home or within a specifically designated space, but no ok elsewhere, for example), temporal (no swimming after dark, for example) or otherwise variable depending on the circumstances, practices and purpose of the boundaries.
Democratic debate about those boundaries is important. But transgression, especially by groups at the extreme margins of the distribution, is not necessarily socially desirable. Societal changes which reduce attempt to discrimination in relation to some pretty commonplace stuff in society - race, sex, disability, age, sexuality - are desirable, but that doesn’t mean that anything should go.
For example, opening up the boundaries of what is considered ‘normal’ sexuality beyond married, heterosexual couples is definitely a good thing - sex outside marriage and LGB sex are pretty standard things. But the boundaries of what should be viewed as acceptable at all, and what should be acceptable privately and consensually, need to be carefully considered. Normativity around sex being an adult activity or a consensual activity is a very good thing. Similarly, normativity around acceptable times and places for activity and display related to sexuality is a good thing : what is ok in a swingers club is not ok in a school, for example
There is broad societal consensus around boundaries that simply should not be crossed there, and we should treat activism looking to transgress those boundaries as dangerous. Queer theory’s obsession with transgression and insistence that anyone who objects is bigoted and oppressive means that people who’ve been educated to fear accusations of bigotry and oppression are start to imagine that boundaries are inherently bad.