Personally, I have to disagree in some ways, but your piece is raising interesting points.
At least in my city in Canada, pride isn't that overly sexual. It's a week long celebration with plenty of very family friendly events aside from the parade itself.
While some people are having a party, straight people engage in all the same behaviour at plenty of other events. Lots of people get wasted/high on holidays throughout the year, so I think your issue lies with how all humans celebrate in public and not how LGBTQ+ people celebrate in public. All people dance and play loud music in a parade, since that's how a parade works.
The parades is also getting a biased sample since many people from that community who are quieter probably stay home and celebrate with close friends instead of at a loud parade.
I think many groups are evolving Pride into different more inclusive things and I would love more events like that. In my experience, I have seen plenty less riotous events where you might feel more welcome.
I appreciate your view though! It may be different in your are and how you city's culture works.
Also I love the point about having other identities! Definitely my bisexuality is not something I constantly talk about as it's just my sexuality and only one facet of my identity.
Anyways thanks for the interesting take on the matter!