Tensor Network Approaches To Molecular Vibrations And Nuclear Quantum Dynamics