Seeking Advice: Metal Roof Leaks and Rust Damage on 50-Year-Old Manufactured House

Recently, we purchased a property that includes an old manufactured house, approximately 50 years old. The house features a metal roof, which has developed leaks over time. We attempted to patch the leaks with silicone, but during heavy rainfall, it leaked again, causing damage to the ceiling. Upon removing the drywall from the ceiling, we discovered that the metal roof is rusted and damaged.

The leaking area is in a room that the previous owner extended, resulting in a nearly flat angle of the roof. While it doesn't snow often or heavily, during some winters, we do experience significant snowfall. In such cases, snow can accumulate on the roof for days or even weeks, potentially worsening the issue.

We believe that applying multiple layers of silicone might provide a solution to the problem. The size of the room experiencing leaks is around 400 square feet, while the rest of the house is not leaking. Therefore, we are considering replacing or installing a new metal roof only for the current leaking area.

We are hoping to avoid the expense of installing a completely new roofing system if possible. Could you please advise us on the best and most cost-effective way to address this issue? Any guidance you can provide would be greatly appreciated.

I have attached pictures showing the rusted and damaged metal as seen from the room. Additionally, I included a picture of a roof (although it is not of the leaking area) for reference.

Thank you for any advice.