Wow, quite a list.
This is something that I would do in Power Query, are you familiar with PQ?
query 1 = create a list (Excel, Access) with the types (which you can maintain with any changes in the future)
query 2 = your shipping data.
Merging the two queries will create the “lookup” for you by record for the straight forward main ship types, this is the easy part.
For the TEU and other classifications, I would have a go at adding conditional columns in query 2 (in the query editor) and/or column by example.
If that does not work for you it gets more complicated, involving both merging and appending, you need another query that you create from the possible classification combinations.
query 2 =your shipping data
query 3 = TEU classification with the TEU classification query,
This is a special technique that I learned from Oz du Soleil, he publishes very good YT video’s on PQ.
Hope this will get you going, you will need a combination of the above techniques to achieve your goal. Execution is outside the scope of this forum and would be more of a consultancy type of service.