Hello!
It's been a few years since I last worked with Unity, and I can't remember. I also don't have that project anymore, as it was only for testing. As far as I remember, you need to create a child component and rotate it instead of the parent, but you can easily find that on YouTube. Unfortunately, I can't remember exactly how I did it to help you, sorry.