The 'Real Time with Bill Maher' host also opened up about his views on marriage and why he decided it wasn't for him