Neutrinos from supernovae: experimental status and perspectives