The conjunction <em>but </em>is used to express a contrast with something that has been mentioned before. As a result, it indicates an opposing idea between what the speaker's family and friends think regarding his singing abilities.
The rest of the options are incorrect because <em>and </em>introduces additional information; <em>for </em>presents a cause; and <em>because </em>precedes a reason.