Integration of Software-Defined Vehicles and Automated Network Slicing for Advancing Sustainable Transportation