There are several Sea World official hotels, not run by Sea World or operated by them, and not on their property. We went to Sea World/Discovery Cove/Aquatica this last summer, and had a great time. Stayed at the Fairfield Inn. We never drove to Sea World, and it was way too far to walk; we used their complimentary shuttle bus. It was largely fine, but there were limitations which were ridiculous. You can find my posts on here. We would have spent more time at Sea World if the shuttles we're run the right way. Other than the included Quick Queue, I'd advise to stay anywhere and drive to and from.
Loved their parks so much. Would love to go back. Quieter and less intense than a Disney Park. Beautiful. Loved all the shows at Sea World, learned a lot. Aquatica is ok but not nearly as good as Disneys watermarks. However, Discovery Cove is the best thing ever. A most wonderful day.