Shot noise for resonant Cooper pair tunneling