Singer opened up for the first time about her late father's abusive behavior on Wednesday's 'Real Housewives of New York City'