Living in the proximity of any school becomes an issue only if you allow it to. Yes, as you have pointed out, there may be school noises and traffic issues but these can be anticipated and/or minor in nature.
On the positive side, you will benefit from a higher police presence, use of the outdoor facilities, and community school programs & activities. In the real estate business, when buyers with children are looking for an ideal home they often request being located near the school.
The appeal of a home in the proximity of a school will likely depend on the individual's personal needs but don't expect it to be a totally negative feature because there are buyers that will seek this location.
Best wishes with your new home,