Can I open a bank account in Thailand using my hotel address on a Non-O visa, and can I deposit funds from Wise for my retirement visa?

I opened bank account using my hotel as my address, along with passport and Thai phone number (as a tourist) albeit it was over 10 years ago

Just had a friend transferred over from Wise his 0 for the retirement Visa to his SCB account no problem whatsoever

Each bank branch sets their own requirements for opening a bank account. You would need to go to a bank branch and try to open an account to see what they require. Many will require a certificate of residence from immigration as your proof of address. If that's the case, then what the bank requires doesn't matter, it's what your immigration office will accept as proof of your address. Each immigration office sets their own requirements, so you would need to check with your immigration office to see what they require for a certificate of residence.

Wise should be fine to transfer the money, and make sure you choose the correct transfer option for living in Thailand long-term so they will attempt to make it look like an international transfer.

International is not a requirement for retirement extension, but it might be beneficial in the future regardless.