Once a week is definitely too much for aloe. I used to make that same mistake when I was just getting into plants. Aloe is a succulent, it stores water in its leaves, so it needs way less watering than we usually think. In summer water it at most once every two weeks, and honestly just check the soil - if it's still moist a couple centimeters deep, wait a few more days. In winter you can basically water it once a month or even less. The wilted look is most likely from overwatering - the roots can start to rot and the leaves lose their firmness.
As for light - it's the opposite actually, in summer aloe needs maximum sun, it doesn't need to be far from the window. If the leaves start getting pale or stretching out, that's a sign of not enough light. Also check the drainage in your pot - there has to be a hole so water doesn't sit there. You need special soil for succulents or cacti, with sand and perlite, not regular all-purpose soil.
One more thing - repotting in fresh soil can help if the plant's been in the same dirt for a while. Over five years the soil could've gotten compacted and soured. Try cutting back on watering, make sure you have good drainage and repot it in the right soil - it should bounce back.