Long term your waist measurement will shrink a bit or a lot, time will tell. Or gain a bit, if you gain weight if course but you'd be gaining in other areas too so it'd even out. If your genetics are like mine (I'm hispanic, mom had wide hips) then you'll see a 2-5 inch increase in your hips easily and your thighs get a lot bigger. Even so you might not increase much at all. It really just depends on your genetics. However with fat redistribution the shape of your rear will change undoubtedly as well as well the rest of your body. I think the most noticeable though is your butt and the stomach pouch area you gain. It just depends on where your body likes to accumulate it's fat.
Also even if you refrained completely from upper body exercises, a guy's muscles are still bigger vs a woman's just cause of testosterone. So whatever upper body mass and overall muscle tone that testosterone gave you will melt away steadily.
Be prepared for your metabolism to slow down. For some it slows down a ton and for others like myself not much of a change a big change. But it does get slower no matter what though on hrt.
In my case I was always very skinny until I started hrt. Prehrt I was about 115 to 120 at 5'10, just could never gain weight no matter how much I ate. But as soon as I started hrt, I've been gradually gaining weight and have been floating around 142 these days. I keep trying to gain weight cause of my height and I never had that baby fat most people get through puberty. I'm lucky enough for most of my fat to accumulate in the areas I want.
SO EAT EAT EAT!! if you want your boobs and butt to be as full as possible, don't skip meals and drinks tons of water, especially if you're on spiro! But since you're an athlete I doubt you'll have much of an issue regarding your diet.
As far as mental effects are concerned in some cases can be drastic and others not. I remember when I started I had this calm feeling that words just cant describe, like for the first time in my life I finally felt right with my body and mind. I've always been a big cry baby. So breaking down and crying over the smallest things is normal for me but I did find myself to be even more sensitive on estrogen.
Your 5 senses will also change. For example your vision as to how you see color can change. Like becoming color blind or colors suddenly becoming very vivid. Sense of smell becomes more sharp. Your taste buds can change too, you'll discover new foods that you never thought in a million years were for you but begin to taste really yummy. Or current favorite foods are even more scrumptious than before. Don't know if the taste bud thing is true for others though but that's been my experience at least. Since your skin softens, your sense of touch will get much more sensitive. You might find your pain tolerance will shift drastically, in my case it did.
Hair wise, it all changes to female type body hair in time. You'll also see new hairs on your scalp and whatever hair you lost due to the male receding hair line will grow back. You might also notice the hairs on your head become softer and have a bit more shine, especially If you're on progesterone.
I think this sums up most of the general long term effects. Hope this helps!
OH wanted to add WELCOME TO FEMALE PUBERTY!!