The former Manchester City player has responded on social media after the backlash he faced over his Queen comments