Brigham Young is perhaps the most hated prophet for many outside the church (and inside it) because of his connection to racism, polygamy, hard-line reformation, etc. Your son could get bullied, perhaps, but also just not offered jobs or opportunities by people who want to cancel Brigham Young.
I mean, having Brigham Young University on your resume sometimes creates those problems, let alone having it as your given name.