James Broadnax, 37, was executed by lethal injection in Texas after being convicted of the 2008 shootings of two Christian music producers in Dallas, despite his cousin allegedly confessing to the crime