Design Files moving from OneDrive to Sharepoint - Recommended?

I am needing some advice on moving design files from OneDrive (which we have used for years) over to SharePoint.

The company I work for is wanting all employees to shift over to SharePoint due to reliable file saving and data collection. The design team has mentioned that this is a worry due to linking, alias, fonts, brand assets, Creative Cloud use and files currently spread across OneDrive that we use to create our designs.

OneDrive works well, at previous companies we used online servers but I worry about moving our files to SharePoint and having all our links breaking or losing files we need to keep these links working as they have. Also working in Adobe (especially InDesign, Illustrator, Photoshop and Premire Pro) is a worry - will these programmes work on SharePoint?

Any shared experiences/recommendations would be appreaciated as I'm not sure this is the best transition for design process?