There’d be no redirect by default. You need DNS for that domain to actually do something. Go ahead and register, but start looking around for Free DNS services.
Or you can pay the hosting cost here for $5.95 or so per month and that’ll get you a redirect.
Or if the destination of that redirect has a DNS you can use, register here and update the WHOIS information to use that DNS server.