RTE viewers were left in "tears" as the San Francisco Rose spoke about her Irish connections on The Rose Of Tralee