Yes, Tulane has a reputation as a party school. As @jym626 said above, much of that has to do with being in a “party city”. Come Spring semester with all the parade celebrations there’s something going on all the time. Which suggests that all kids are going to all these things. They’re not. There’s little FOMO for the kids going to Tulane because there’s going to be something going on tomorrow and the day after and the day after.
It’s not a situation where one local bar has live music on Thursday nights so all the college kids flock there. All the bars have live music every night. Unless the student would has a tendency to get distracted to their own demise - it’s not something I would really worry about.
The school currently has a 3 year on-campus requirement so while there might be some “party houses” they number far less than schools where the majority of the students live off campus.
And there’s PLENTY of students that don’t party or don’t join Greek life and/or don’t do XYZ. It’s a school of 8K students - which is much less than many a large state flagship but a size that’s going to have people of all walks of life.
That said - I also agree with others that you should do a nice long visit to any school that you’re considering transferring to.
OP mentioned being able to play music where they land. If they have any current musical ability they would be welcomed in any of the ensembles at Tulane. They’re always looking for new students to participate.