Israeli ally joins calls for lowering tensions at holy site after record-breaking number of Jews visit on Jerusalem Day