A footballer who was expecting his second child with his partner died after a car mowed down pedestrians in Nottinghamshire.