I think there’s a misunderstanding. I was trying to convey in my previous comment that Google does not allow me to create a hotspot with my mobile data turned off.
I put my SIM in my backup phone, a OnePlus Nord N10, to prove it to you. I can create a hotspot with my mobile data turned off on it.