I'm fine with people being able to live their lives without being harassed
I think that's a fairly common attitude. I know I don't think people should be harassed or discriminated against because of their sexual preference. My only issue is when they want to start denying reality. Getting angry for being called a man when they identify as a woman for example, or wanting to use the wrong restroom... I'm fine to let people dress and act however they want, it's only when they try to force others to entertain their fantasies and give them special treatment that I start to take issue.
Wholeheartedly agree with your last statement. It has now gone to ridiculous levels that you can get cancelled for trying to answer the "What is a woman?" question. You've probably heard of the issue with "Lia" Thomas. It's frustrating to see these happening.