Are there only two irreducible affine singular cubic curves?
If you remove some (non-singular) points from the curve $y^2=x^3$, you get a singular cubic which is still affine (it is an open affine subset), yet it is not isomorphic to the original curve. Indeed, any isomorphism would induce an isomorphism between the regular loci of the curves. These loci are just projective lines minus finitely many points, and the isomorphism class determines the number of missing points.
EDIT. This argument is partly relevant because I forgot that the OP asks for affine plane curves. However, one can give a counter-example to the OP's question.
Note that the cubics $y^2=x^3$ and $y^2=x^3+x^2$ have only one point at infinity. Let's try for a singular plane cubic with three points at infinity. Consider the family of plane cubics $$C_k : x^3+y^3+kxy+1=0.$$ The singular fibers are given by $k \in \{-3,-3\zeta_3, -3\overline{\zeta_3}\}$. For example, when $k=-3$ the (unique) singular point is $(x,y)=(1,1)$ and is a node. The regular locus of $C_{-3}$ is isomorphic to the projective line minus 5 points, hence $C_{-3}$ cannot be isomorphic to the above cubics. I don't know however if $C_{-3}$ (or other singular plane cubic curves) can be isomorphic to open subsets of these two cubics.
EDIT 2. A simpler example is given by Descartes's folium $x^3+y^3=3axy$ for any $a \neq 0$. It has the singular nodal point $(0,0)$ and again 3 points at infinity.