The vagina is not supposed to be "tight"
it's good to have a strong pelvic floor as this can prevent prolapse and incontinence
Levels can be done to strengthen the floor.
Narrowing of the vagina can occur with large reconstructive mesh, radiation andold age. Vaginal "tightening" as promoted by a small group of gynos is an interest driven primarily by our countries obsession with porn.