While photos gave the impression of a grand spectacle for the guests, including Sydney Sweeney, sources have shared how the wedding was 'exhausting' for those attending