No. AirTags require another Apple device with bluetooth to 'find' it, and with WiFi (or celluar connectivity) to report its location back to the AirTag owner, who would also need WiFi or cellular connection to access this data.
Even if it did report 'location' it would be in 2 dimensions, not 3. If you have ever checked where your luggage is at an airport, you get a 'bird's eye' view, so an AirTag at best might show where on the ship is was (fore, midship, aft) but not the vertical component such as which deck.