The Oak Ridge National Laboratory (ORNL) Spallation Neutron Source (SNS) First Target Station (FTS), used by the COHERENT experiment, provides an intense and extremely highquality source of pulsed stopped-pion neutrinos, with energies up to about 50 MeV. Upgrades to the SNS are planned, including a Second Target Station (STS), which will approximately double the expected neutrino flux while maintaining quality similar to the FTS source. Furthermore, additional space for ten-tonne scale detectors may be available. We describe here exciting opportunities for neutrino physics, other particle and nuclear physics, and detector development using the FTS and STS neutrino sources.