Comparison of transverse single-spin asymmetries for forward $\pi^{0}$ production in polarized $pp$, $p\rm{Al}$ and $p\rm{Au}$ collisions at nucleon pair c.m. energy $\sqrt{s_{\mathrm{NN}}}= 200$ GeV