Prime Minister Albanese was picketed by locals at a "YES" event in Stirling